Archive for June, 2011

Tip for optimizing MySQL data types

Posted in MySQL, Software Development on June 28th, 2011 by Jeff – Be the first to comment

This is a tip that I’ve kept forgetting to write down so here it is:

During a system’s life cycle, requirements change and components are refactored. This includes databases as well, and particularly as data grows. Decisions and assumptions are made at the beginning of a system’s life cycle that may or may not hold up over years of operation and it’s good practice to continually analyze how well the initial design is working.
read more »