If you are using subselect then it gobbles up memory like there is no
tomorrow. Try using a stored procedure with simple queries.
Date sent: Thu, 20 May 2004 14:30:36 +1200
From: "Steve Aish" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [DUG] Dealing with large amounts of data - comparing
Send reply to: NZ Borland Developers Group - Delphi List <[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]>
> Hi y'all,
>
> I have a database that records approx 500,000 records per week in one
> table.
>
> I want to compare week 1 and week 2 for example to see which of a
> certain field are in week 1 but not in week 2.
>
> I am using Interbase.
>
> I thought of running a query (until my pc ran out of hard drive space
> with the temp file size).
>
> I thought the easiest (although probably not the best) way would be to
> fill in a stringlist (I am only worried about 1 field) with week 1 and
> then fill another stringlist with week 2 and then compare them. I just
> open a query with one field in it and iterate through the query and
>
> List.Add(Query1.FieldByName('Field').asString);
>
> This runs out of memory after 200,000 records or so. It is not the
> string list running out of memory - it is the Query1... ??? Confuses
> me.
>
> Any ideas?
>
>
> _______________________________________________
> Delphi mailing list
> [EMAIL PROTECTED]
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
Regards
Rohit
======================================================================
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH (649) 489-2280
FX (649) 489-2290
email [EMAIL PROTECTED] or [EMAIL PROTECTED]
======================================================================
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
