Oct 15 2008
MySQL Data Types - Benchmarking The Perfect Database
When benchmarking your database, you have several options of data types, you must concentrate in all the possible data that you may have to store in a specific field.
Choosing the right data type will make all the difference when in production environment, the right MySQL structure will have the maximum performance, which means that your applications will run faster, however bad data types for certain data will kill your application.
If you are one of those persons that use VARCHAR for everything (or almost), you’ve been missing all the MySQL power.
Continue reading…