--- In ib-support@y..., "chriskudla" <chris@o...> wrote:

> We are trying to speed up updates and queries on our Firebird
> database. Is
> there anything to be gained in setting transactions to 'read-only'
> before
> starting them?

Chris, if transaction is really intended only to read and it is
read_commited - yes, this can increase general performance in
multitransanction(user) environment, but not a particular statement.
This effect is because such a transactions don't affect gap oldest
active transaction - next transaction so don't require to hold old
data versions even if this transaction are long. All the database
become cleaner and server is less loaded, but speed of particular
statement depends on structure of this statement itself.

Best regards, Alexander V.Nevsky.