The slow update is because you commit for every update. If you commit a bit
less (e.g. for every 10000 changed rows), your application will run much
faster. It is possible to process several thousand records per second.

Set

At 19:04 23.06.2003 +0700, you wrote:

>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. :)