Hi Guys!
I am running a MySQL query on my server that seems to be causing a massive spike on the server and I really don’t know how to fix it. When I run the query in phpMyadmin it takes 3.75 seconds to execute. The table only has 31,000 rows but my query is doing a few joins (INNER, LEFT).
Is there anyway to speed it up? Most of my queries run in under a second…I just wanted to know if this is normal for a query to take this long.
Thanks in advance.