On Wednesday 14 January 2004 12:27, Sezai YILMAZ wrote:
> Richard Huxton wrote:
> >There's plenty on this in the archives, and probably the FAQ too.
> >
> >What are you using the count() for?
>
> I use count() for some statistics. Just to show how many records
> collected so far.
If you want an accurate number without scanning the table, you'll need to use
a trigger to keep a count up to date.
--
Richard Huxton
Archonet Ltd