Guest Deleted Posted July 1, 2013 Share Posted July 1, 2013 I'm developing a PBBG where people raise and breed animals. Each animal will have around two hundred stats. These need to be stored in the database. I was thinking of having a text field and storing all the stats in one big, serialized array. Then whenever the site needed to analyze the stats of an animal, it would pull that array, unserialize it, and get the information it needs. Is this terribly inefficient? Would it be better to give each stat its own column? Note: My host only allows my database to be up to 2 GB. Link to comment Share on other sites More sharing options...
HartleySan Posted July 1, 2013 Share Posted July 1, 2013 Yes, pulling each array from the DB and analyzing the data that way is very inefficient. If you don't want a lot of columns, then you may want to consider a NoSQL option like MongoDB. Link to comment Share on other sites More sharing options...
Recommended Posts