Subject | Re: [firebird-support] Re: Very fast read only transactions |
---|---|
Author | Ivan Prenosil |
Post date | 2009-01-22T11:18:40Z |
> Yes. A transaction, regardless of mode, has a beginning and an end. It begins with TRANSACTION START and ends with either COMMITBecause read-only transaction can't modify data, it will be internally always committed,
> or ROLLBACK. Period. Adam already mentioned that COMMIT uses less resources than ROLLBACK - so commit read-only transactions if
> you want to conserve a bit of resource.
regardless whether you use COMMIT or ROLLBACK (i.e. you will see no difference
between the two)
Ivan