if you're serious about mysql, do not inadvertently add a tab in your queries
 

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 :thumbsup

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 :1orglaugh