In 18.104.22.1680 I have made the observation that SAConnection is slower than OdbcConnection for simple operations going through tcp/ip like:
OdbcConnection myConnection = new OdbcConnection("dsn=xxx"); myConnection.Open(); OdbcCommand myCommand = myConnection.CreateCommand(); myCommand.CommandText = "SELECT 1"; myCommand.ExecuteScalar(); myCommand.Dispose();
With Odbc it needs ~310 ms and uses 29 TCP/IP packets,
with SA it needs ~350 ms and uses 48 TCP/IP packets
Have there been any performance improvements regarding this situation in current versions of the iAnywhere.Data.SQLAnywhere?
asked 14 Nov '11, 12:18
I can think of two improvements that have been made to version 12 that may help.
One is a round trip during the connect sequence has been eliminated for both ODBC and ADO.Net.
The second is connection pooling is enabled by default. In order for connection pooling to be helpful, the same process must connect at least 5 times with the exact same connection string, disconnect and connect again with the same connection string.
answered 15 Nov '11, 08:50