| Lists: | pgsql-hackers |
|---|
| From: | Vladimir Romanov <vromanov(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | ODBC Driver performance comparison |
| Date: | 2014-09-05 05:54:14 |
| Message-ID: | CAJ4CROhxObLnG9zP68BoxedRUzzqe+9L2UdnBKxfj5+jJhRvzA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
--
Vladimir Romanov
| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | <vromanov(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ODBC Driver performance comparison |
| Date: | 2014-09-05 06:41:59 |
| Message-ID: | 54095B37.6040206@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
