Re: Dramatic performance drop when table > 100MB
Thanks a lot - that was the problem indeed. I had a
PRIMARY KEY (time,msgid)
in my table definition but it turns out this does nothing for queries on msgid (only helps queries on time, or both time and msgid). "EXPLAIN SELECT" showed that quite clearly.
Creating an index for msgid solved the issue completely.
Still wondering why it did work (up to 100MB table size) but that's probably some kind of MySQL optimization for small tables.
Subject
Views
Written By
Posted
3869
November 01, 2004 09:48PM
2644
November 02, 2004 06:46AM
2502
November 02, 2004 10:38AM
Re: Dramatic performance drop when table > 100MB
2958
November 02, 2004 04:14PM
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.