Switch to new code base tomorrow!
I’ve decided to switch the site over to the new code base tomorrow. This means that we’ll have moved away SQLObject and will be deploying under mod_python.
I am slightly concerned that there are still issues with the new code, ideally it would have been tested more thoroughly. However it is so staggeringly improved that I think it is with moving even if there are some problems. The speed increase is from anything up to 8000 ms to generate a page down to 60 ms!
It looks like that it’s the removal of the CherrpyPy WSGI middleware which is responsible for most of this speed-up. I started by deploying under mod_wsgi which initially looked great but under load it failed to show any improvement over my original setup. I think that the fault lies with CherryPy’s WSGI so the solution is to bypass it completely with mod_python.
I’ll get up early and do it first thing which is the quietest time. If there’s any problems I will just revert back.