Subject Efficient Record Count
Author dkLists
All -

I have a large table with approximately 1 million rows that will be continually growing over time. It is useful to be able to review the recordcount whenever I run my app and add/delete data. I've been trying to come up with an efficient way to maintain a 'running' record count without loading the entire dataset to the client, i.e. autofetchall.

Would it be much faster to do this in a stored procedure? If so, would it be as simple as doing a SELECT COUNT(*) FROM TABLE? If not, is there a particular IBObjects component that should be used?

All advice welcome.

Thanks in advance.
GreatLand Technology


[Non-text portions of this message have been removed]