Hello all! I do some test with ODBC driver for PosgreSql, TimesTen & MySQL. I compare performance on very simple request. Database always located on same PC as test application. Test PC - Lenovo T500, Cnetos 6.5 64, 8 Gb RAM, SSD. I found what PostgreSql ODBC driver is slowest in comparison. IMHO problems related to protocol used. I can't use SHM connection to server or even UNIX socket.
Actually, you can use a UNIX domain socket with psqlodbc. Just put the path to the socket, e.g. "/tmp", in the Servername property, instead of the hostname. That's assuming psqlodbc was compiled with libpq support, (--with-libpq configure option), but I'm pretty sure that's the default on all major distributions.
Would be interesting to get the psqlodbc function names in the chart. Any chance you could re-run the benchmark with a debug-enabled build?
It's interesting that 10.7% of the runtime seems to be spent in __tz_convert() function, called indirectly by SQLExecute. Off the top of my head, I don't see where that call is coming from. I wouldn't expect SQLExecute to do much with timezones, at least when there are no timestamp fields involved.
It might also be fairly straightforward to optimize the sprintf/sscanf function calls. They're probably used to convert between integers and strings, and it should be possible write some sort of fast-paths for those conversions.
Are you measuring wall-clock time or CPU time? If it's CPU time, I'm surprised that the I/O-related syscalls, poll(), send() and recv(), are so high on the profile. If not, there isn't much you can do in the client side to make them faster, as the time is simply spent waiting for the server.
