Page 1 of 1

Storage design for a dynamic grid

Posted: Sun May 03, 2009 8:36 am
by mickd
I'm having a bit of problems designing a database that stores custom sized dynamic square grid objects (roughly 6x6 in most cases), where each of the squares in the grid could possibly be another grid object, or hold information.

As you can see, it would get quite big fast, and I'm not sure what i can do to be able to store lots of them (when created) into a database, and still be able to retrieve and reconstruct it fast under load (without just serializing, which the output seems too big and slow).

If anyone has any suggestions or know of any typical storage techniques that could help, that would be great.

Thanks!