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 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…