auroragb on 16 May 2007
ioi said: 4) The server isn't particularly unstable, rather it gets a huge amount of traffic. Generating one of those charts takes up a lot of computational time, same with calculating totals and so on since it is all done dynamically on the fly. I have been trying to speed up our queries and do things to take load off the server a little, so things should be more stable now than they were but if you are having specific problems please email me... |
Can't you run a nightly job that generates the chart once a day or even once a week? There is only so many variants and the data doesn't change much during the week. This way it will reduce the server load.
Also, why is the 360 < 7million? shouldn't it be 9.7?
