And that's the only way. FB does not have a counter of the number of rows
anywhere.

Artur

----- Original Message -----
From: "Kenneth Foo" <kenneth@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, April 05, 2002 4:46 AM
Subject: Re: [ib-support] SELECT COUNT(*) ... - slow


> I'm experiencing the same thing.
> The solution I had was to maintain a table of counts, and update this
table
> accordingly via use of triggers.
>
> Regards
> Kenneth
>
> ----- Original Message -----
> From: "yeohray" <yeohray@...>
> To: <ib-support@yahoogroups.com>
> Sent: Friday, April 05, 2002 9:21 AM
> Subject: [ib-support] SELECT COUNT(*) ... - slow
>
>
> > I have a table with 1 million+ records. When I ran a query to count
> > the number of records e.g. SELECT COUNT(*) FROM MyTable, the query
> > took about 20 seconds to complete. Is there any way to speed these
> > sort of things up (maybe a system table somewhere?)?
> >
> > Thanks in advance.
> >
> > Yeoh
> >
> > Specs:
> > Win2000 Professional
> > AMD Duron 800
> > 192MB RAM
> > Firebird 1 Beta 2 (clients are still using IBO :)
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com