I never saw that method when it first came around, but man it's nice.
That's another solution for the 'Handy Bits' folder!

N

> -----Original Message-----
> From: Alexandre Benson Smith [mailto:iblist@...]
> Sent: Tuesday, 1 March 2005 9:09 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Performance of the count Function.
>
>
>
> Mitchell Peek wrote:
>
> >YES! Very nice solution to both problems. Very good.
> >
> >
> Thanks to Ann who has pointed it out, if I needed a fast count I will
> keep the count on a record that will be updated by the
> triggers, but as
> you pointed out the update will be a bottleneck.
>
> Ann showed us a very nice and elegant solution. If you search the
> archives maybe you will find her message.
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1012 (20050228) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>