Post by houkouonchi » Thu Dec 06, 2012 3:51 pm
[quote="Izzy"]Yes, by a factor of at least 5.
What did you change? Different indexing?[/quote]
I did add some indexes on some columns in some tables but the biggest thing was enabling query cache for the tons of queries that are constantly being ran. I thought it was already enabled but I found it was not. This increases memory usage but decreases load/cpu usage and increases load time by a ton in most cases.