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


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

Visits by Source

User Actions

Users who voted for this posting

Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


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