Additional
Overview
Features
Known issues
FAQ
Support
Credits and license
History
Download
Forum
I must download big dataset to client. But after 30.000 records i am going off memory ... PDF Print E-mail
Sep 19, 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.}
 
Previous   Next