| Subject | UPDATE: Slow Firebird results first time I query, but fast thereafter |
|---|---|
| Author | blizzardb2001 |
| Post date | 2009-08-27T11:36:26Z |
UPDATE...
Okay so I ran some more tests. It seems that just about any select statement from any of the tables is very slow the first time, very fast the next time.
I create a dataset called QryTest.
I set the SQL to "SELECT "ID" FROM "TblBookings"
Close.
Open.
Takes 12 seconds.
Close.
Open.
Takes 1 second.
Change the SQL to a complex SELECT statement.
Close.
Open.
Takes 12 seconds.
Close.
Open
Takes 1 second.
INSERT STATEMENTS however are very fast.
I am using Zeoslib and Delphi BDS 2006
Okay so I ran some more tests. It seems that just about any select statement from any of the tables is very slow the first time, very fast the next time.
I create a dataset called QryTest.
I set the SQL to "SELECT "ID" FROM "TblBookings"
Close.
Open.
Takes 12 seconds.
Close.
Open.
Takes 1 second.
Change the SQL to a complex SELECT statement.
Close.
Open.
Takes 12 seconds.
Close.
Open
Takes 1 second.
INSERT STATEMENTS however are very fast.
I am using Zeoslib and Delphi BDS 2006