Subject Re: [firebird-support] How does sweeping works?
Author Dmitry Yemanov
Daniel Vogelbacher wrote:

> I've added one record to the table;
> SELECT count(*) from bigtbl; returns 1 (< 1sec.).
>
> Next, I've added 500.000.000 records inside a transaction and after
> that, I rolled back the transaction (database file is now at 5gb).
>
> count(*) needs now a long time (I've canceled after ~30min).

What FB version? How many indices do exist for the table?


Dmitry