Hello,
i have remarked a strange thing, if you do only one transaction by connection
these counters are not updated , it is normal ?
i have done the test with dotnet provider and node-firebird (they uses the xdr
remote protocol).
it is very easy to reproduce :
1) Open Connection
2) Open transaction
3) do a select query
4) hard commit on transact
5) Close connection
ps : if i do a second transaction on the same connection these counters are
updated.
so if you do a little script that launch N times this little program you
obtain with gstat -h
IF N = 100
BEFORE :
OIT 1, OAT 2, OST 2, Next 3
AFTER
OIT 1, OAT 2, OST 2, NEXT 103
[CODE => DOTNET]
using FirebirdSql.Data.FirebirdClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace dotnet_firebird
{
class Program
{
static void Main(string[] args)
{
FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder scnx =
new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder();
scnx.UserID = "SYSDBA";
scnx.Password = "masterkey";
scnx.DataSource = "127.0.0.1";
scnx.Database = "c:\\test.fdb";
int i = 0;
FbConnection cnx = new FbConnection(scnx.ToString());
cnx.Open();
FbTransaction tr = cnx.BeginTransaction();
FbCommand cmd = new FbCommand("SELECT COUNT(1) FROM TRANSACT",
cnx, tr);
FbDataReader _reader = cmd.ExecuteReader();
while (_reader.Read())
Console.WriteLine(_reader.GetString(0));
_reader.Close();
tr.Commit();
i++;
cnx.Close();
cnx.Dispose();
}
}
}
[/CODE]
[CODE => node]
var fb = require('node-firebird');
var _connection = {
user : 'SYSDBA',
password : 'masterkey',
host : '127.0.0.1',
port : 3050,
database : 'test.fdb',
}
fb.attach(_connection, function (err, cnx) {
if (err) {
console.log("can't connect to db");
return;
}
cnx.query("SELECT count(1) FROM TRANSACT", function (err, data) {
console.log(data);
cnx.detach(function (err) {
if (err)
console.log(err);
});
});
});
[/CODE]
