[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/