Reading large table

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jlund
Posts: 22
Joined: Wed 17 Nov 2004 18:50

Reading large table

Post by jlund » Tue 25 Aug 2009 14:13

Hi.

I am reading a large table and writing it to a SDAC table, and I have discovered that the entire table is being read into memory although I have made it unidirectional and set fetchrows to 100.

The result is, that the table consumes more an more memory as the proces runs.

Is there a way to read the table in chunks of about 100 records, dropping them out of memory as the next 100 records are read ?

TIA Jens Lund
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 25 Aug 2009 15:09

To solve this problem you should use the FetchAll and UniDirectional properties.
Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.
Top
jlund
Posts: 22
Joined: Wed 17 Nov 2004 18:50

Post by jlund » Wed 26 Aug 2009 07:12

Oops - sorry

It was the SDAC table that grew - problem solved

/Jens Lund
Top
Post Reply

Return to “MySQL Data Access Components”