Postgres Pro
Downloads
Home   >   mailing lists

psqlodbcw.so vs libodbcpsql.so - Mailing list pgsql-odbc

From Mike Landl
Subject psqlodbcw.so vs libodbcpsql.so
Date
Msg-id 00ba01cefa96$2b87edd0$8297c970$@com
Whole thread Raw
Responses Re: psqlodbcw.so vs libodbcpsql.so  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List pgsql-odbc
Tree view

Hi All,

 

Apologies if this a simple and/or naïve question but what exactly is the difference between psqlodbcw.so and libodbcpsql.so?

Obviously psqlodbcw.so is your driver but what exactly is libodbcpsql.so and do people still use it (I am using PostgreSQL 9.1.4 at the moment in case that is relevant information)? Maybe I haven’t been searching correctly but I haven’t been able to come up with much useful information.

The reason I’m asking is because I have tried both and libodbcpsql.so seems to be approximately 5x faster in my tests. Are there known issues with this driver?

I want to use your driver since I know it is actively being worked on and is the official ODBC driver for PostgreSQL but the speed differences are huge.

If you need any more information from me (i.e. log files) just ask.

Thanks.

 

 

Mike Landl

4GL Solutions

1020 Denison Street, Suite 101

Markham,ON L3R 3W5

 

Website: www.4glsol.com

Phone:    (905) 479-6727

Fax:        (905) 479-1246

 

pgsql-odbc by date:

Previous
From: ljwilson
Date:
Subject: Re: Windows Compile warnings: C4018 signed/unsigned mismatch and C4723 potential divide by 0
Next
From: PG User
Date:
Subject: support for keep alive option