Additional
Overview
Features
Get
Discuss
News
Known issues
FAQ
Support
Credits and license
I must download big dataset to client. But after 30.000 records i am going off memory ... PDF Print E-mail
Sep 18, 2006
 I must download big dataset to client. But after 30.000 records i am going off memory. What i shoold do ?

You shoold use TOCIQuery for data downloading. And set for excellent performance and resource usage it properties (there are only values, that differs from defaults):

  • UniDirectional = True 
  • FetchParams.RowsetSize = 1000 {or bigger. It is constrained only by existing memory.}