Subject Odp: [firebird-support] Query slowness

1. Garbage collection - many old record versions after update or massive deletion.

2. You have another connection - and after first select data pages go into RAM but you say that you use classic is tis true or may be you use superserver or superclassic?

Karol Bieniaszewski

----- Reply message -----
Od: "garethm" <GARETHM@...>
Do: <>
Temat: [firebird-support] Query slowness
Data: pon., cze 3, 2013 08:56

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

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