Subject | TIB_Query.next consume memory? |
---|---|
Author | anfisoft |
Post date | 2002-09-27T20:24:57Z |
My really huge Query-result is about 130.000 records big. I have to
look at each of the records for some reason and coded:
with IB_Query1 do
begin
open;
first;
while not(eof) do
begin
// here some outcommented code
next;
end;
close;
end;
i saw at the taskmanager that my app consumes more and more memory
while seeking trough the results. I did more checks with AllocMemSize
and found that each "next" consumes 48 Bytes of memory
(130.000x48~6MByte for the whole loop), the Taskmanager reports even
more memory usage: ~45Mbyte!!! I think each 48 Byte "delphi-memory"
produce even more memory-consumption in the real world.
Q: How can i seek through results WITHOUT loosing memory??
Q: did the gds23.dll do the AllocMem
Thanks for your help!
Andreas Filsinger (Germany)
PS: i set "readonly" to "true", fetchwholerows to "false", some other
things - no difference!
look at each of the records for some reason and coded:
with IB_Query1 do
begin
open;
first;
while not(eof) do
begin
// here some outcommented code
next;
end;
close;
end;
i saw at the taskmanager that my app consumes more and more memory
while seeking trough the results. I did more checks with AllocMemSize
and found that each "next" consumes 48 Bytes of memory
(130.000x48~6MByte for the whole loop), the Taskmanager reports even
more memory usage: ~45Mbyte!!! I think each 48 Byte "delphi-memory"
produce even more memory-consumption in the real world.
Q: How can i seek through results WITHOUT loosing memory??
Q: did the gds23.dll do the AllocMem
Thanks for your help!
Andreas Filsinger (Germany)
PS: i set "readonly" to "true", fetchwholerows to "false", some other
things - no difference!