> Hello @ll, > > > > we are using firebird 3.0 RC2 and have some questions about open > transactions. (Clients connect over odbc) The gstat output gives 70000 > transactions between the oldest and the current transaction, if we look into > the monitoring table, we see only 10 transactions. The "oldest one" we > cannot find in this table. What is the oldest transaction and which roll > does the garbage collector play? If we have many open transactions, the > performance is bad. What role plays the attachments? What is the best way to > check the performance bottleneck in such cases?
Please post an entire gstat -h output. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.