Subject | Re: [firebird-support] Performance of the count Function. |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-02-28T22:09:11Z |
Mitchell Peek wrote:
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
>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