Subject Performance improvements for an embedded database after hibernation
Author Alec Swan
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?



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