Indexing problems
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.
Subject
Written By
Posted
Indexing problems
October 25, 2004 07:31PM
November 07, 2004 01:25AM
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.