|Subject||Re: [firebird-support] Re: Holding a connection open forever|
> In response to your questions:Auto commit usually used commit retaining which retains the physical
> What are the implications of holding a connection to the database open
> forever (and running millions and millions of tiny transactions flat out
> through that connection)?
> What difference would it make if we dropped the connection periodically?
> We had a similar issue with long running connections, and finally
> resorted to dropping the connection periodically.
> One thing I noticed in our gstat -h output was that the oldest
> transaction number was not moving forward. I could not never figure out
> why. We use auto commit and ODBC, not explicit transactions. Dropping
> the connection every few hours resolved our problem.
transaction context thus your stuck transaction counters.
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.