mark
User
Fresh Boarder
| Posts: 2 |   |
Karma: 0
|
|
Memoryproblem with NCOCI8 1.0.2
|
|
Posted: 2004/04/19 07:30 |
|
|
|
|
Hi,
I'm using this great oracle component-set within delphi 6 (sp2) to transfer data from an oracle database to another target. I've run into a strange behaviour:
The following code is used to do the transfer. The adressed table has something round about 3,000,000 records. ociQDef is of type TOCIQuery
while not ociQDef.Eof do
begin
// Insert the values into another target. Commented out for testing, so there's only reading..
Inc(rcount);
if (rcount Mod 1000)=0 then Write2Screen('.');
if (rcount Mod 100000)=0 then Write2Log('Fortschritt: '+IntToStr(rcount)+
' Datensätze. '+DateTimeToStr(Now));
ociQDef.Next;
end;
This loop just eats up the memory!? Looking at the process monitor I see a steady increase of the allocated memory by the application. After 2,000,000 records, the allocated memory for the application is at 180MB, beginning at 11MB at startup after initialization. Than it will raise an exception, since there's no more memory available.
Does anybody has any idea why this happens or has a workaround for me?
Thanks in advance!
Regards,
Mark.
|
|
