> I have absolutely NO idea what this pseudocode is trying to do but,

I can understand that. It only describes the process, not the purpose of
the code.

> if it's supposed to represent something you are doing with DbXpress,
> then it's totally bizarre.

Before you know what the code intend to do, I know everybody will say
that. For the purpose I'm trying to reach, that's the best algorithm
I've ever found. Believe me. :)

> This isn't a Delphi forum, but I suggest you get into the demos
> directory of Kylix and load up the demos from the db folder to
> see how it's done.

I know that, and I'm not asking you to discuss about the algorithm,
neither Delphi. That's why I wrote it in pseudo. :)

> if you never call a hard Commit then there is absolutely NO
> garbage collection happening.
> ... deleted ...

Yup!! That's the answer, hard COMMIT, without RETAIN. After I commented
the COMMIT RETAIN and placed a COMMIT after the most inner loop, the
problem gone away. I got a persistent database file size, though the
application run slower (it took about 7 mins to finish the loop). As
long as it run stable and consistent, that's ok for me. :)

Thank you, Helen. :-) All your explanation helps me much. And also to
other people here, thanks for the responses.

Regards,

-Bee-



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.486 / Virus Database: 284 - Release Date: 29-05-2003