Re: commit every x rows (V6)
From: Martin Farber <farber_at_nynexst.com>
Date: 15 Feb 1994 14:27:52 GMT
Message-ID: <2jqm59$m0f_at_news.nynexst.com>
Date: 15 Feb 1994 14:27:52 GMT
Message-ID: <2jqm59$m0f_at_news.nynexst.com>
Noel, is not addressing the original problem. Autocommit only takes effect AFTER a statement has completed! Which doesn't help if there is delete, insert, or update that is effecting a great many rows.
Truncate helps with the delete problem, but doesn't fire delete triggers! FOR UPDATE OF does generate errors. The solution we came up with was PL/SQL loop using the ROWID the specify the row to be deleted/updated and then COMMITing every so often. ROWID is the next fastest way of getting there!
Good luck!
<<MFF>> Received on Tue Feb 15 1994 - 15:27:52 CET