I got a mysql query
in php, that does a join on a large table (90GB)
query takes somewhere between 7 and 20 seconds
I need help to speed this up.
I can show the query on the private message board.
You need to be real experiences with mysql, experience with optimizing and tweaking performance.
I think indexes are on the right place, and "explain" shows that they are being used
please basic mysql skills will not be sufficient to solve this problem.
If you are a mysql guru, this should be an easy buck