|Subject||RE: [ib-support] Record Count|
> From: Woody [mailto:woody.tmw@...]While a count() should not take as long as the 'real' query -- it is
> Sent: Wednesday, November 07, 2001 3:37 PM
> A Count(*) query should not take that long regardless of the number of
> records. It is performed on the server side so it should
> return quickly.
incorrect to think of it as a 'no-cost' solution.
Due to the Multi-Generational Architecture of Firebird/IB, a record
count can require a fair bit of processing and as such I would
**strongly** recommend that it not be done (i.e. forget about the count
of rows for a query!)