Diman
Admin
Admin
| Posts: 1461 |  |
Karma: 18
|
|
Re:Error "Out of memory"
|
|
Posted: 2008/01/27 00:50 |
|
|
|
|
Hello
If it comes from AnyDAC, then due to following reason. Your application fetches large rowset's and AnyDAC cahes all fetched records. Like a X * 1,000,000 of records, where each record has many fields, etc. Often that happens if to execute SELECT * FROM LargeTable or to use TADTable with LargeTable.
If some of that are your cases, then consider:
- replace or TADTable with TADQuery
- check that each TADQuery working with LargeTable has SELECT with WHERE
- if application does not need to visualize dataset or walk through it backward and forward, but only forward, then set Unidirectional to True
There are additional considerations to minimize memory usage, but listed above are the primary considerations.
Regards,
Dmitry
|
|
