Subject Query slowness
Author garethm

I am currently using Firebird using Classic Server 64-bit. The database file was created with Firebird and is 546MB with a page size of 8192. The server and client are both running on my Windows 7 64-bit development machine.

I ran the following query using FlameRobin:


This query took 8 minutes 56 seconds to run, and returned a result of 131822 rows.

I then closed FlameRobin and reopened it. The same query ran in 0.117s.

I know that doing a database sweep can cause queries to run slowly, and Flamerobin indicates that the sweep interval is set to 20000. Is the sweep the only possible reason for the performance difference between the two runs of the query with classic server if each run is done on a new connection to the database?

Is 9 minutes a typical time to sweep a table with 131822 records in a 546MB database?

Gareth Marshall