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(a)Wikipedia.org; intlwiki-l(a)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(a)Wikipedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l