[GENERAL] slow query performance

2003-10-31 Thread Dave Weaver
I'm having severe performance issues with a conceptually simple database. The database has one table, containing weather observations. The table currently has about 13.5 million rows, and is being updated constantly. The database is running on a dual 550MHz PIII with 512MB RAM. On the whole, que

Re: [GENERAL] slow query performance

2003-10-30 Thread Dave Weaver
Jeff wrote: > Dave Weaver wrote: > > For instance: > > SELECT station, air_temp FROM obs > > WHERE station = 'EGBB' > > AND valid_time > '28/8/03 00:00' > > AND valid_time < '28/10/03 00:00'