On Mon, 2003-04-28 at 03:30, Erik Moeller wrote:
As I wrote you by private mail, I think people would be much more willing to accept a temporary deactivation of the sysop SQL feature, which, if at all, should be run on a separate machine (possibly a mirror, could really be 1-2 days out of date).
I have only very rarely seen slowdowns caused by sysops making SQL queries, whereas the special pages and the search cause much more continuous states of slowness as they are constantly pounded on.
Yes, you are correct, they are very rare. But if they occur, they will effectively slow down all other queries for the time they run. Because of the risk that such an out of control query can slow us down for hours, I think there's really no argument that can be made for keeping them active, unless we implement a timeout (which would mean you or Lee, because I frankly never cared much about the SQL feature). That doesn't mean that we should not consider other options for speedings things up as well (although I agree that the server situation needs to improve in any case).
Regards,
Erik