February 5th, 2013, 10:09 PM
Very slow MySQL query
I have a MySQL query which takes quite a while to load. This is very frustrating for users when they do a search as it can take up to 10 seconds for the page to load. When I execute the function in phpMyAdmin it says the query took 1.34 seconds but in fact takes about 10 seconds for that page to load too.
I also run an EXPLAIN on the query and took a screenshot of the result. Any help to speed this query up would be greatly appreciated.
February 6th, 2013, 12:59 AM
unfortunately, my pirated copy of Microsoft® CrystalBall© is down at the moment, so i can't see the EXPLAIN from here
Originally Posted by Luis93
you'll just have to post it