|
Posted by reandeau on 11/03/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
Navigation:
[Reply to this message]
|