|Subject||Re: [firebird-support] Limitting maximum database file size|
> Right button for the cause of the bloat, wrong button forThat's a new term for me. Can you explain it?
> fixing it. Your solution is known as "throwing the baby
> out with the bathwater".
> The process flow is well hidden by your pseudocode, butYup. I've optimized my code to do that. I think, beside the update
> your hard commit should NOT occur for every row. One of
> your loops (and only you can know which one) should be
> counting rows updated and, when this count gets to
> 10,000, you call commit.
process, the thing that slow my application down, is the commit itself.
Because after a commit, the connection is broken and I have to
re-connect to the server. I hope I can optimize my code so it can finish
its task below 5 minutes.
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