MySQL and Performance Problems
Over lunch today I finally resolved the last blocker issue on the newly set up UFies.org box. Everything went in fine but I found while doing some testing on a site with large database tables that performance sucked! The problem could be narrowed down to a query which takes 0.1s on a heavily loaded debian …