--- In firebird-support@yahoogroups.com, Doug Chamberlin <chamberlin.doug@...> wrote:

>
> On 4/12/11 3:54 AM, Kjell Rilbe wrote:
> > Since others have replied there is no such API function, perhaps it's
> > worth sontemplating what's "cheaper":
> >
> > 1. start trans, read generator, commit
> >
> > or:
> >
> > 2. start trans, read generator, rollback
> Commits to transactions that have not touched table records are
> essentially the same as rollbacks. Or, rather, rollbacks are essentially
> commits. Even for transactions that only read data. No big difference.
>

I second theres no big difference.
But I remember read in this list, (and in http://www.ibexpert.info/ibe/index.php?n=Doc.DataTransaction), that someone said that for FB is better if you commit for read-only transactions.

Anyway, I must agree with Norman. Third option is the best! :)