Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

Can I get RecordCount without doing a Fetch All?

https://forums.devart.com/viewtopic.php?f=5&t=9794

Page 1 of 1

Can I get RecordCount without doing a Fetch All?

Posted: Fri 18 May 2007 16:56
by gymwalker
TOraTable.RecordCount gives me only the #' of records fetched so far...so to get ALL the records in the table I need to set TOraTable.FetchAll to True...this is ok for a small table...but I have some tables with MILLIONS of entries...so is there a quicker/faster more efficent way to get the # of records in a table without doing a FetchAll?

Thanks in advance...

Jim

Posted: Mon 21 May 2007 07:26
by Plash
You should set the QueryRecCount option to True for the TOraTable component. In this case the component will perform an additional query to get record count.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/