Subject Re: [IBO] Fastest Count
Author Lester Caine
Bill Gage wrote:

> What would be the fastest and most efficient to return the value of
> a SELECT Count(*) statement? What component should be used?

1/ Not return it at all. It's very heavy on processing, so if you have a
need to return counts on a regular basis think about managing them in a
separate table which is updated by INSERT and DELETE triggers.

2/ For occasional use, then IB_DSQL is probably the best choice, and
just execute it when ever you need it.

Lester Caine
L.S.Caine Electronic Services