0
votes
Vote UpVote

Using FireDAC Unidirectional property for fast, low memory selection set processing

Sip from the Firehose – I often do large Oracle database queries using FireDAC to analyze registration data about our products and customers. Most of the time I am only processing through millions of rows to create a report or chart. One of the FDQuery properties that I forget to set True is the TDFQuery's "Unidirectional" sub-property found under the FetchOptions (TFDFetchOptions) property.  By default Unidirectional is set to false as some developers will want to put the data into a grid or other container and update the values. In my case, when I left Unidirectional false and read through millions of rows ...
Favorite? Off-Topic? david.intersimone@embarcadero.com @ 2015-12-29 18:03

Statistics

Visits: 29
Votes: 0
Favorites: 0
Off-Topic: 0

Visits by Source

User Actions

Users who voted for this posting

Subscribe:
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News

Sponsor

 
Please login or register to use this functionality.
(click on this box to dismiss)