UniLoader.LoadFromDataset loads only the amount of records set in FetchSize
Posted: Thu 15 Aug 2013 13:27
Hi,
I am using UniDac 5.0.2 and Delphi XE4.
I am trying to load a large Table containing a blob field with UniLoader from firebird to sqlite (with direct mode and encryption).
When I use UniLoader.Load and call mySourceTable.Next after processing a completed row in the OnGetColumnData event, everything works. Using the LoadFromDataset method, the UniLoader only processes the number of records which is set in the FetchSize property of the source table.
Setting the FetchSize to the total amount of records is no option for me because that leads to an out of memory exception.
I have read about a similar problem which is fixed according to the release log but for me it seems there's still sth. wrong.
Let me know if you need further details.
Martin
I am using UniDac 5.0.2 and Delphi XE4.
I am trying to load a large Table containing a blob field with UniLoader from firebird to sqlite (with direct mode and encryption).
When I use UniLoader.Load and call mySourceTable.Next after processing a completed row in the OnGetColumnData event, everything works. Using the LoadFromDataset method, the UniLoader only processes the number of records which is set in the FetchSize property of the source table.
Setting the FetchSize to the total amount of records is no option for me because that leads to an out of memory exception.
I have read about a similar problem which is fixed according to the release log but for me it seems there's still sth. wrong.
Let me know if you need further details.
Martin