cur_user_text and old_user_text are "tinyblob", so MySQL won't index them.
I'm not sure, however, if we should make big changes to the database
anymore. The new source from Lee is pretty stable and has a more elaborate
database structure. Try
=Magnus_Manske
for an example of the user contributions.
As we will switch to that codebase when we switch servers, there's probably
no need to fix minor bugs here for the time being.
Magnus
-----Original Message-----
From: wikipedia-l-admin(a)nupedia.com
[mailto:wikipedia-l-admin@nupedia.com]On Behalf Of Jan.Hidders
Sent: Sunday, June 30, 2002 5:28 PM
To: wikipedia-l(a)nupedia.com
Subject: Re: [Wikipedia-l] Wikipedia software; Apache vulnerability
On Sun, Jun 30, 2002 at 10:26:19AM -0400, Pierre Abbat wrote:
I suspect it is searches for users' contributions. These always take a
long time and almost always time out, even when browsing was fast just
before I do one. It makes no difference how many contributions the user
has made. Perhaps an index is missing and needs to be made.
Er, surely the developer who programmed that ...
Jimbo? Could you check if there is an index on 'old_user_text' in
the table
'old' and on 'cur_user_text' in the table 'cur'? If not please
tell MySQL
the following:
ALTER TABLE old ADD INDEX ( old_user_text );
ALTER TABLE cur ADD INDEX ( cur_user_text );
-- Jan Hidders
[Wikipedia-l]
To manage your subscription to this list, please go here:
http://www.nupedia.com/mailman/listinfo/wikipedia-l