|Subject||Re: [firebird-support] Firebird and transactions question|
> I friend of mine recently told me that you should do everything inEvery client request (DDL, DML) is in context of a transaction. If you
> 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.
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:
According to the session descriptions and the people involved, worth
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.