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