are you really using tables? not queries?
Alan

> -----Original Message-----
> From: Gary Jones [mailto:nonesuch1960@...]
> Sent: Wednesday, 13 August 2003 10:38 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Out-of-memory problem
>
>
> Hi,
>
>
> I'm using Firebird 1.03 with Delphi 5 and am experiencing a
> frustrating problem. Here's the situation:
>
> (I know that tables wouldn't normally be used in the way described
> below in a C/S environment, but I'd like to know what's going on.)
>
>
> Table1 has these fields:
> Componentcode, life (51 records)
>
> Table2 has these fields:
> Uprn,componentcode,duedate (1.1 million records)
>
>
> Pseudocode of what I'm doing:
> ########################
> table2.open;
> table2.first;
> while not table2.eof do
> begin
>
> // Run query to look up value of "life" field from table1
> // using componentcode as the joining field.
>
> // Assign value of duedate field in table2 based on value
> of "life".
>
>
> table2.next
> end;
> ########################
>
> Table2 has no filters set and the only index that is the primary
> key, which does not include duedate (the field being changed).
>
>
> The application gets through around 600,000 of the 1.1 million
> records in table2, then falls over with an "out of memory" error.
> Watching the application processes in Windows Task Manager while the
> application runs gives no indication that the application is using
> anything like all the PC's available memory.
>
> Any clues what's going on? Thanks.
>
> Gary
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>