Database application:Out of resources

[nanin]

I'm programming a grid application which shows records from a SQL Server DataBase through an ADOConnection. The number of records is about 10000. The problem is that when I pass from a record to another in the DataGrid the amount of memory increases slightly (4-8 KB/reg). Finally, the application crashes: "Out of application resources". If I minimize the application, it restores its allocated memory to 1-2 MB since 20,21 or more MB (it depends of operations over the grid).

I compile the application in release mode, builded without runtime packages and without dinamic RTL.


how could deallocate the memory from the non-visible records?Any solution?

Thanks in advance!!

 

[VintageWine]

I assume you mean 4-8KB per record. A lot, unless includes memos.

A 10,000 record grid? Hardly a pinacle of user friendliness.

Suggestion 1. How about limiting the number of records in the grid by implementing a search facility of some sort?

Suggestion 2. For the 10,000 record dataset, use the minimum of fields and certainly no memo fields. Have a second dataset containing all fields, but only selecting those records that you really need to act on.

Suggestion 3. Check out properties of TADODataset like CursorLocation, CursorType, LockType,


Hope this helps
Simon