Subject RE: [firebird-support] Re: Facing Problems in executing the Select query
Author Dean Harding
> > everything is happening within the context of a transaction.
> > The transaction IDs have to written
> > Alan
> >
> Thanks for your post. But could you please elaborate a little more?
> We are not very clear about this...

What he means is that every statement that you execute in Firebird is done
in the context of a transaction. That means that stuff needs to be written
to the transaction log for every statement.

However, if you're doing SELECTs on only a couple of tables, it is quite
likely that much of the data that is SELECTed is already in memory, which
means that it won't necessarily have to perform a *read* I/O for every


[Non-text portions of this message have been removed]