[fdo-internals] Counting rows in managed IFeatureReader
Jason.Birch at nanaimo.ca
Wed Apr 23 12:21:54 EDT 2008
Are there any concerns about the number of records changing between the
first SelectAggregates and the Select, or are all providers
transactional across a single session?
From: Robert Fortin
Subject: RE: [fdo-internals] Counting rows in managed IFeatureReader
The 1st select should be a selectaggregate call using function Count()
where it is available. This will be optimized for most provider, will
avoid a full table scan and will limit the number of trip to the server.
The 2nd is to process those rows as needed.
More information about the fdo-internals