Re: [Firebird-devel] Out-of-memory problem

[Alexander V.N. <de...@hq...>]

Wednesday, August 13, 2003, 2:36:45 PM, Gary Jones wrote:

GJ> I'm using Firebird 1.03 with Delphi 5 and am experiencing a frustrating
GJ> problem. Here's the situation:

  Gary, this list is for discussion of FB engine develop, please post
support questions into Firebird-support group on Yahoo.

GJ> Table2 has these fields:
GJ> Uprn,componentcode,duedate (1.1 million records)
[skipped]
GJ> The application gets through around 600,000 of the 1.1 million records in
GJ> table2, then falls over with an "out of memory" error.

  Delphi component limitation. When you need process large cursor set
Unidirectional property to true, so already processed rows will not
be cashed to be scrollable backwards.

Best regards,
Alexander