How to guarantee that there is only one transaction at the
same time updating the count?

--Mikko

> -----Original Message-----
> From: ext Kenneth Foo [mailto:kenneth@...]
> Sent: 05 April, 2002 06:46
> To: ib-support@yahoogroups.com
> 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
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> SALE --> Wireless Video Cameras
> for Home Surveillance! VERY TINY! PRICE BREAKTHROUGH - $79.99!
> http://us.click.yahoo.com/W0toNC/7o6DAA/yigFAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/