It is currently Mon Feb 17, 2020 3:28 am


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


 Page 1 of 1 [ 1 post ] 
Author Message
 Post subject: Odd things happening...
PostPosted: Sun Oct 05, 2003 4:35 pm 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
If you notice any odd things happening in the game today it may be because we are making changes to some of the database code.

Whoever setup some of this initially needs to be shot.

To give you an example. When you change production on your planets using the display that shows ALL of your planets and allows you to change settings on all of them guess what happens? There are 13-15 database queries made for EACH planet! If you have 100 planets that's 1,300 to 1,500 queries that are made. This is a HUGE hit to the database. Image if you have 500 planets (like some have in the Megaverse) that is 6,500 to 7,500 queries executed in rapid succession. Speaking of a load on the server.

The really sad part is that only ONE of the queries pulls data to be used. The others all update the SAME planet multiple times.

This is totally unneeded (I really want to whack the original programmer with a hammer.). That one program has now been reduced to 3 queries as a quick fix. But it will be reduced to only a single query per planet in the final later today.

So we have been going through the files and targetting the really stupid things that cause unneeded massive queries. So you may see some odd things happening now and again as things are changed. Go ahead and report them as bugs but we wanted to warn everyone.

Let this be a lesson to anyone who wants to take over a game and change it. :) It ends up being alot of work and can sometimes turn into more work than starting from scratch. :?

Sorry for any problems that come up while this is ongoing.


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


Who is online

Users browsing this forum: No registered users and 2 guests


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