I’m ill. :-(

So only a short post today. Opera have released more data from their MAMA survey, including this gem:

MAMA used a MySQL SMALLINT data type (max. value: 65,535) to store the quantity of comments on a page. Surprisingly, in the most extreme cases this was not big enough. Only 1 URL was found to exceed this in MAMA’s URL set [...] http://genforum.genealogy.com/ny/all.html. MAMA stored its maximum value of 65,535, but a live analysis showed 146,376 comments in a 9.2MB HTML file!

Very True Mood: (sick) sick

One Comment

  1. One thing I’ve learnt about database design is sooner or later whatever data type you’ve used for a field someone will come along with something bigger than you allowed for or the fixed maximum length will be increased by the appropriate standards body. Once you’ve lived with a database designed by an “expert” who unfortunately thought a number (5) was a good key for many database tables you learn the lesson of how to change constraints and datatypes…

Leave a Comment


(will not be published unless you behave like a spammer or a troll)