Subject Re: Slow 1st query
Author Ian A. Newby
Hi Menjit

> i have a software that uses Firebird embedded v. 1.5 on winxp sp2. My
> problem is when i launch the application, the first query is very slow
> (about 1.5 minutes). The database is a .fdb. The next query is very
> fast. I use index on the table (i have only one table with 8 fields).
> How do i solve the problem?

I believe that your problem could be XP's system restore function.
Assuming you db file extension is .gdb, then system restore treats it
as a protected file and copies it when it is first accessed.

To aviod this, rename the db with a .fdb extension, or turn off system

Ian Newby