Jur Schagen wrote:Your suspicions are right, this _is_ about the animals. The sheer volume takes processing them into the hours, and that four times a day. As player requests (using the game interface) come on in concurrently, there's a turnaround point where all processes jam up into eachother and all processing bogs down into snail speed, waiting for scripts to unlock tables that don't get finished, and turning to "Cantr is down" pages.
Since animals are an integral part of the game, we can't just turn them off. We have decided to reduce their cycles from four to two times per day for now though - this should result in less lag in the 21:30-23:30 CET interval, which is he most problematic, because both European and American players are online then. Some lag will probably still occur after 03:30 and 15:30 though.
This measure affects the entire animal system (reproduction, travel, attacking, etc), if you see significant problems in-game because of this (in particular, animals getting extinct unexpectedly), please report them here. We are looking to get back to normal animal processing in a few weeks.
This is a temporary measure - we intend to take the animal processing to a secondary database so the regular player processing don't get affected. This requires some substantial programming though, which Chris will take up after his holiday. In the meantime, I will look over the relevant scripts as well to see if I can find any way to optimize them (though don't get too over-excited about the latter - I'm not that good really). Thirdly, we're looking to cap the total animal count (which has risen to about 2 million, while it used to be around 1 million before the lag) in conjunction with RD.
We are very sorry for the problems, but must ask you to bear with us for just a little longer. There will still be lag moments over the coming period, but they should be reduced significantly. Please be patient, we are aware of the problems and looking fo solutions.
Now in my old day job I would at this point bring a pointed finger down on the table top, making several little thumping noises, and announce that what has been suggested is not cost effective. I would point out that huge resources have already been devoted to this system, yet it fails to meet objectives. There is no likelihood either that the suggested fixes will do anything more than incur further costs to little avail. It must therefore be backed out of. I would here make further thumping noises and proclaim it "wrong in concept". At the sound of those words the system anaylysts would slump back in their seats and senior management would perk up and start frowning at said analysts. Because those three words were my code words to senior management for "dump it".
Yes, once upon a time I was a business analyst. So all I can do is ask you to trust my gut feel. Please let's vote to request ProgD to back out of the current system of individualized animals and return to the old statistical system. It would instantly cure the lag without any risk, and the risk is very great, that trying to maintain individualized animals will continue to suck up more and more programming time and more and more money (eg backup servers and the like).

