SQL Access for admistrator could be disabled to improve speed ? Is it really a need ?
-----Original Message----- From: Brion Vibber [mailto:brion@pobox.com] Sent: 20 August 2003 13:46 To: wikitech-l@Wikipedia.org; intlwiki-l@Wikipedia.org Subject: Re: [Wikitech-l] Slow, very slow, very very slow, much too slow
Constans, Camille (C.C.) wrote:
I agree with Anthere and Luc, sometimes, I get a page in
half a seconde, sometimes in 2 minutes !
Well, as over time the various wikis get larger and bring in bigger audiences, their database needs grow. The English wiki, big and slow, is about the size of the others combined; but the others have been running with all kinds of features still in place that have been disabled on the English wiki because they slow things down too much.
As a temporary measure I've turned on the annoying limiter functions that we've got on the English wiki (no counter updates, several of the slower special pages disabled) for French, German, Japanese, Swedish, Dutch, and Polish. These are the biggest ones, and the one's I've been seeing a lot of slow/stuck database queries running on. (Not user-run queries, but special pages and searches.)
I also put the French wiki in read-only mode to run checks on the tables, just in case there was something specifically amiss. It looks okay (thankfully!) and should be up and running again.
-- brion vibber (brion @ pobox.com)
Wikitech-l mailing list Wikitech-l@Wikipedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l