Subject | Re: [firebird-support] How does sweeping works? |
---|---|
Author | Dmitry Yemanov |
Post date | 2009-08-27T07:36:26Z |
Daniel Vogelbacher wrote:
Dmitry
> I've added one record to the table;What FB version? How many indices do exist for 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).
Dmitry