One of the harder debugs, but for all you coder folk out there, did you know that adding a \t (tab) in your mysql queries in PHP will slow shit riiiiiiiiight down in complex queries?
I didn't, now I do
that's a typo problem I'll never make again!!
What I don't get is on the command line, mysql doesn't allow tabs (not even copy/paste), yet PHP will do something with tabs that allows the command to execute, albeit at much reduced efficiency.
A lesson learnt that was the difference between constant load 80 and load 8.
Rack that into the gfy education sub-series
