News about StepMania Online.
3 posts • Page 1 of 1
Izzy wrote:Yes, by a factor of at least 5.
What did you change? Different indexing?
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.
Who is online
Users browsing this forum: No registered users and 1 guest