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
http://www.piclab.com/wikitest/wiki.phtml?title=Special:Contributions&ta... =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@nupedia.com [mailto:wikipedia-l-admin@nupedia.com]On Behalf Of Jan.Hidders Sent: Sunday, June 30, 2002 5:28 PM To: wikipedia-l@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