Subject performance in firebird
Author cosamektoo
I have a server written in java that read and writes to a db
over solaris on intel.
I have a client that run on solaris on sparc,using SQL API.
The client only reads data.
The problem I encounter is that after some work,
the next transaction number becomes far from the oldest snapshot number.
If I force the client to read something from the database, the numbers
become closer.
How can I solve, this problem. I dont want to force the client to
perform "Idle" reads.The client commits after every read and running
with isolation level read_commited.