Posted by reandeau on 12/18/09 11:49

> The lags persist on MySQL server (locally), so it's not a network
> issue. The lags are espeically bad when I do a query like "SELECT
> name, phone, notes FROM reservations WHERE date > %today%" - it
> literally takes 5-6 seconds to pull one row.

Try adding indexes to fields in the table that you are searching on.
ALTER TABLE reservations ADD INDEX (date);

Let me know how it goes.

Jon Tjemsland

[Back to original message]