Can I get RecordCount without doing a Fetch All?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gymwalker
Posts: 9
Joined: Wed 09 May 2007 23:53
Location: San Diego, CA

Can I get RecordCount without doing a Fetch All?

Post by gymwalker » Fri 18 May 2007 16:56

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
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 21 May 2007 07:26

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.
Top
Post Reply

Return to “Oracle Data Access Components”