Friday, June 1, 2012

Expect brain delays of up to 5 hours

9:00AM
- This query is really slow! Is killing me! How to fix it?
- The problem is it's doing a fulltext search. Make sure that the table is MyISAM and add a fulltext index.
- Ok got it!

* Herbert enters intense coding mode for a few hours *

2:00PM
- What if I added a fulltext index?
- *sigh* Yeah, that could work

2:30PM
- Should it be a MyISAM table?
*facepalm*