We are running Firebird 2.1.2 in an embedded mode on Windows XP SP3. The
database size is pretty small (less than 50MB). The majority of data is
stored in 4 or 5 tables with 20,000 rows each.

Our users complain that it takes 30 seconds to execute a query right after
the machine comes back from hibernation. The following executions of the
same query take 4 seconds. Is there a way to speed up the first query
execution right after hibernation?

Thanks,

Alec


[Non-text portions of this message have been removed]