> I friend of mine recently told me that you should do everything in
> Firebird in the context of a transaction. If you are only
> inserting/updating/deleting one record then surely you don't need a
> transaction. Or if you only do one DDL change then surely you don't need
> a transaction? I can understand if your transaction involves multiple
> records or multiple DDL changes.

Every client request (DDL, DML) is in context of a transaction. If you
haven't started an explicit transaction up-front, your client access
layer usually creates an implicit for you then.

Transactions are a crucial part in the Firebird universe. Treat them as
your friend and not as your enemy. Research, learn and breath them.

If you get a chance, join one of the next stops of:
http://www.firebirdsql.org/en/firebird-conference-tour-2013/

According to the session descriptions and the people involved, worth
every penny.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.