In my bookmarks too.

I have often worried about the performance penalties of select count,
and have resorted to triggers to maintain a separate table however I
didn't know how to get around what is effectively a table lock.

Brilliant compromise!

Is there a scheduler planned for FB, or maintaining this another job
for an isql script in the windows scheduler or service sitting on the
server?

Adam

--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@e...>
wrote:

> 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@t...]
> > 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
> >
> >