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.