You Never Know Who You’re Helping
Talking in the #cakephp channel (just replaced some info):
- someguy: anyone know how I could improve the mysql index for a where of WHERE ((some_field < 3) OR (some_field = 1)) AND otherfield_id = (1006)
- me: someguy, what about to add an index for otherfield_id ?
- someguy: that did improve it
- someguy: heh, I already did the first to on the production db
- someguy: cpu usage went down
- me: cool
- someguy: yeah
- someguy: the DB had become the bottleneck
- me: is that a public site ?
- someguy: yes
- me: can i see it ?
- someguy: http://www.missuniverse.com
LOL 
Categories: Programming
