>WEBESCON Commit Trans 6/6/2012 2499515 1735.774
>WEBESCON Login 6/6/2012 859 0.59
>WEBESCON Logout 6/6/2012 858 0.595
>WEBESCON Start Trans 6/6/2012 2499516 1735.775
>WEBESCON Commit Trans 6/7/2012 657036 456.275
>WEBESCON Login 6/7/2012 232 0.161
>WEBESCON Logout 6/7/2012 231 0.160
>WEBESCON Start Trans 6/7/2012 657035 456.274
>
>These are the number of connect(Login), disconnect(Logout) and transactions.
>As you can see they are connecting/disconnection some 1700+ times each minute
>during the entire day. In my eyes its an total overkill.

1700 connect/disconnect does sound like a lot (and some kind of connection pooling would be advantageous), but I cannot see that from the numbers you report. What I see is 1700 commits per minute, there seems to be almost two minutes between each connect/disconnect.

What are these 1700 transactions actually doing? Do you have some Firebird statistics like oldest transaction/next transaction etc.?

Set