Leon,

Commit when you would like to make a certain unit of work permanent.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hi,
> Would it be wise to fire COMMIT (or COMMITRETAINING) between sql-
> statements that influence a lot of records (100.000) or is it better
> not to ?
>
> Examples (simplified in order to enhance reading)
>
> Method A.
> STARTTRANSACTION
> delete from customers
> COMMITRETAINING
> insert into customers
> COMMIT
>
> B.
> STARTTRANSACTION
> delete from customers
> insert into customers
> COMMIT