Subject Re: Is some API to get generator value?
Author emb_blaster
--- In, 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, 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! :)