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