Subject Re: [IBO] Fastest Count
Author Bill Gage
Well our databases are so huge that we have to split them down into
separate databases for each month.

--- In, Lester Caine <lester@l...> wrote:
> Bill Gage wrote:
> > I don't think I fully understand your alternate solution. Do
> > mean to populate that table with the counts? In the situation I
> > in this is not an option because the actual SQL statement is
> > dynamically and there could be an infinite number of variations.
> That is often the case, but I have some key 'counts' calculated
> triggers, and the 'dynamic' ones calculated in IB_DSQL. When I
need to
> calculate percentages, I have the total ( the big number ), and
> dynamically calculate the smaller values. We are only talking
> amounts of time, but with sites now reaching 250000 transactions,
it's a
> lot quicker calculating the years total by sum of 12 monthly
> than counting 100000 records cold ;)
> Until you start hitting several years of data, it may not be a
> but it's worth bearing in mind if some totals ARE used regularly.
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services