Database Design
• Select the right column types
– No bigger than you need
– MySQL provides a ton of column types
– Use NOT NULL where it makes sense
– Use fixed column sizes if you can
• MyISAM tables with fixed rows are faster
• Concurrency improvements
– Store compressed data when possible
See: http://www.mysql.com/doc/S/t/Storage_requirements.html
Copyright 2002, Jeremy Zawodny (Jeremy@Zawodny.com)