On [Thu, 27.08.2009 11:36], Dmitry Yemanov wrote:

> 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?

Firebird 2.0.5 SS Win32

There exists only one index for a varchar(20) column.
But afaik a simple count(*) without a WHERE clause isn't using
any indicies, so it's not an index issue.


Daniel


--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)