|
|
Posted by TristaSD on 11/24/90 11:49
Hi,
I wrote a php+MySQL-based reservations system for a local restaurant.
MySQL is running on AMD Athlon 3000+ 2GHz with 1.5Gb of RAM. The
system is accessed through Intranet by 4-5 machines.
The main reservations table weighs only 40k with around 150 entries,
but I'm getting weird lags in the middle of the pages - half of the
table loads ... LAG! ... then the other half loads. This is especially
annoying considering the table will contain around 3,000 - 5,000
entries per year, entries older than 2 years will be removed.
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.
I don't use "SELECT ALL" queries, my tables are optimized, etc.
Help!
Navigation:
[Reply to this message]
|