|Subject||Re: [ib-support] SELECT COUNT(*) ... - slow|
And that's the only way. FB does not have a counter of the number of rows
----- Original Message -----
From: "Kenneth Foo" <kenneth@...>
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
> accordingly via use of triggers.
> ----- Original Message -----
> From: "yeohray" <yeohray@...>
> To: <email@example.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:
> > firstname.lastname@example.org