Performance of PGOLEDB compared to other drivers?

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Performance of PGOLEDB compared to other drivers?

Postby philipp.johannis » Fri Dec 13, 2013 2:13 am

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
philipp.johannis
 
Posts: 2
Joined: Thu Dec 12, 2013 9:46 am

Re: Performance of PGOLEDB compared to other drivers?

Postby Moderator » Sun Jan 05, 2014 10:01 pm

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
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm

Re: Performance of PGOLEDB compared to other drivers?

Postby philipp.johannis » Mon Jan 06, 2014 1:07 am

Hi,

Thanks for your reply. I contacted the support.

BR
Philipp
philipp.johannis
 
Posts: 2
Joined: Thu Dec 12, 2013 9:46 am


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: Google [Bot] and 2 guests