Hi,

At May 26, 2003, 18:26, Roque wrote:

> :. What is the fastest way to count records in large tables? Or is there a
> way to count faster the records of a table?

Unfortunately, no. When you perform a count, Firebird or Interbase has
to count all the records of the table that matches the search
criteria, and go through all the record versions that are not yet
garbage collected to know which version of the record to include in
the counting process.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)