[ic] slow mysql search

sda sda interchange-users@lists.akopia.com
Sun Jun 3 13:28:01 2001


I am using mysql and the database has 60,000 rows.
Search on an indexed text field usually takes less
than 3 seconds. 
But, occastionally, it takes over 25 seconds.

I do not see memory swap on
my machine when this slow search occurs.

Does anyone know what could possibly cause this
occasional slow search?  

thanks in advance,
steve




__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/