Storage design for a dynamic grid

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mickd
Forum Contributor
Posts: 397
Joined: Tue Jun 21, 2005 9:05 am
Location: Australia

Storage design for a dynamic grid

Post 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!
Post Reply