Re: ODBC Driver performance comparison - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: ODBC Driver performance comparison
Date
Msg-id [email protected]
Whole thread Raw
In response to ODBC Driver performance comparison  (Vladimir Romanov <[email protected]>)
List pgsql-hackers
I just replied to this on pgsql-odbc mailing list. Since we're talking 
about client performance, please keep the discussion there.

On 09/05/2014 08:54 AM, Vladimir Romanov wrote:
> 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.
>
> perftool report - http://freepcrf.com/files/db_test_pq.pdf
> chart 1 (w/o timesten)  - http://freepcrf.com/files/drv_comp1.png
> chart 2 - http://freepcrf.com/files/drv_comp2.png
> test source - https://github.com/vvromanov/db_test
>
>

- Heikki




pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Escaping from blocked send() reprised.
Next
From: Joel Jacobson
Date:
Subject: Re: PL/PgSQL: EXIT USING ROLLBACK