Quote:
Originally Posted by mikev
We are running Statslab 11 v2.2.0 beta in the GUBA. Recently we switched our ratings from 1-10 to 1-20.
Now I'm getting messages from my hosting service saying that the Development Update is running abnormally slow and causing a high load on the server:
What I'm being told is that the dev update is an inefficient SQL query that needs to be optimized -- were any changes made to newer versions or would updating to Statslab12 make a difference?
Thanks
|
Mike, I have a few online leagues on allsimbaseball that are experiencing the same thing. Some very high CPU usage as queries are taking a long time to retrieve stuff from the database. I sent a PM to fhomess regarding some SQL subqueries that were found and one acquaintance of mine familiar with SQL advised using "joins" in the SQL queries instead. Hopefully he can address this issue soon.
__________________
Fidel Montoya
Asahi2 Baseball ex-Commissioner(Historical League Since 2004)
www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)