Performance of PGOLEDB compared to other drivers?

More
6 years 5 months ago #10701 by philipp.johannis
philipp.johannis created the topic: Performance of PGOLEDB compared to other drivers?
Hi,

I would like to know if there is a white paper or a data sheet which compares the performance of the PGOLEDB with other PostgreSQL drivers, i.e. the ODBC. The reason I am asking for this is because with the trial version we can't compare the performance due to the limitation to 100 rows. But a superior performance would be the main reason to buy the server edition. Maybe it would be possible to get an "extended" trial with a limit of 10,000 rows?

Thanks in advance.

Best regards,
Philipp

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #10736 by Moderator
Moderator replied the topic: Re: Performance of PGOLEDB compared to other drivers?
Hi Philipp,
we compared performance of OLEDB vs ODBC vs libpq. In most cases OLEDB is noticeably faster than ODBC, but 3-5% slower than libpq. The performance advantage varies on the different fields types in a table, row size, and number of rows. Please contact Support to obtain a temporary unlimited version of the OLEDB provider to perform comparison.

Thank you
Moderator

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #10737 by philipp.johannis
philipp.johannis replied the topic: Re: Performance of PGOLEDB compared to other drivers?
Hi,

Thanks for your reply. I contacted the support.

BR
Philipp

Please Log in or Create an account to join the conversation.

Time to create page: 0.083 seconds
Powered by Kunena Forum