MySQL Forums
Forum List  »  General

Indexing problems
Posted by: James Woodward
Date: October 25, 2004 07:31PM

We've recently moved a database to an Apple X-Serve running
mysql Ver 12.22 Distrib 4.0.18, for apple-darwin7.0 (powerpc)

I've created an index on the analyst column with the command
create index analyst on helpbounce(analyst(3) asc);

I've found that right after I create the index it takes this query
SELECT id, creationdate AS unixdate, lastedit
FROM helpbounce
WHERE analyst='jaw2' AND category!='spam'
AND category!='Helpbounce Change Request'
ORDER BY morelater, replysent desc, lastedit desc;

0.59 seconds to return.

But after about a day it starts taking up to 14 - 45 seconds to complete the same query. If I re-create the index again everything comes back to about .59 seconds again.

Any idea's?

James

Please let me know if this is not the correct forum to ask a question like this. Also if I need to include more information such as a table description I can do that as well.

Options: ReplyQuote


Subject
Written By
Posted
Indexing problems
October 25, 2004 07:31PM
October 25, 2004 07:49PM
October 25, 2004 08:25PM
October 25, 2004 08:39PM
October 25, 2004 08:55PM
October 26, 2004 08:15PM
October 26, 2004 08:22PM
October 26, 2004 11:11PM
October 26, 2004 11:29PM
October 27, 2004 12:01AM
October 27, 2004 01:21AM
October 27, 2004 01:20PM
October 27, 2004 06:34PM
October 28, 2004 10:03PM
October 29, 2004 02:20AM
November 07, 2004 01:25AM
October 26, 2004 11:34AM
October 26, 2004 01:48PM
October 26, 2004 02:14PM
November 10, 2004 11:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.