|
I must download big dataset to client. But after 30.000 records i am going off memory ... |
|
|
|
|
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.}
|