It is currently Mon Feb 24, 2020 8:36 am


The forum is READ ONLY. Please direct any future discussions to our Facebook page


 Page 1 of 1 [ 4 posts ] 
Author Message
 Post subject: Optimization Patch
PostPosted: Fri Mar 05, 2004 5:04 am 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
Sometime in the next few days we will be making availible an Optimization Patch download for everyone running the game.

This patch will greatly increase the speed if the scheduler. On one of our games with thousands of planets, thousands of dignitaries/spies and thousands of sectors with defenses it can take 30-40 seconds for the scheduler to finish. Players will notice this as the countdown timer resetting to 300 when they refresh the screen. This also causes the biggest load on the server because there are tens of thousands of database queries happening everytime the scheduler runs.

This Optimization Patch can speed the scheduler up by 10-20 times but there is a catch.

In the documentation we recommended everyone should be using MySql 4.0.3 or higher because there are many optimizations in that version and later. This Optimization Patch is going to require MySql 4.0.3 or higher to be installed for it to work. You can still install the patch but if you have an older MySql version or you aren't running mysql it will fall back to the old SLOW updates.

The Optimization Patch uses linked update queries which is only availible in MySql 4.0.3 and above. This means we can have ONE query to update all of the planets with birth rate increaser dignitaries. The old method uses 2 queries per planet with php calculations between each query. So 1,000 planets with birth increasers would mean 2,000 database queries. With the optimizations it is only 1 query. So 2,000 vs 1... Guess there is a reason to have the latest version of MySql installed. :D

If the testing goes well look for the Optimization Package sunday or monday.

This will greatly reduce the load on large games and things should seem faster. :D


Last edited by Panama Jack on Sun Mar 21, 2004 4:22 pm, edited 1 time in total.

Offline
 Profile  
 
 Post subject:
PostPosted: Fri Mar 12, 2004 7:55 pm 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
Well, some people tonight may have started to notice that both of our games have started to get a little peppier when loading pages. We were hoping to have the optimization patch finished last week but some other things came up and delayed it.

I have been adding in the new code slowly today and we have dropped the scheduler execution times down by almost half and it will go even lower as the rest are added. The added plus is far, far less server load. If all of the changes work as they should as I add them we may have the patch ready late this weekend.

once it is available it will be flagged a priority download. There are speedups for people trying to run the game on older versions of MySql but the screaming speedups will come to those running My.Sql 4.0.3 or higher.


Offline
 Profile  
 
 Post subject:
PostPosted: Tue Mar 16, 2004 4:21 pm 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
Almost ready to release. :D


Offline
 Profile  
 
 Post subject:
PostPosted: Fri Mar 19, 2004 6:08 am 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
I know it is agonizing to have to wait but it will be well worth it. :)

Just about every schedule program has been modified. I have two left to finish updating. Ship Towing and Autotrades. Not much of a change to Ship Towing but the Auto Trades will have a majot speedup. Another area with a major speed up has been sector defense degrading.

Schedule execution time has been reduced to an 8th of what it was. People running a small 5k map may only see the schedule take 1-3 seconds and most times less than 1 second. Before the server upgrade we had the main game schedule time drop from 65-70 seconds down to 10-13 seconds. That's a huge difference.

Since with the new server upgrade the main game schedule runs 5-7 seconds. So there have been some huge changes in speed. If the changes to the above mentioned programs go well look for the optimization patch to be released by saturday.

And it is easy to update your game to support the patch. You just run the same install.php program that you used to setup the game the first time. When it asks if you want to edit setting enter your password and click submit. Don't change any of the settings but save your config. It will save with the new data automatically. You are done. Simple and easy.


Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 4 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

cron