Have you tried 08.01.0003? Is all logging turned off?
If it is still slower, can you describe your workload, and how you execute queries (prepared?, declare/fetch etc?).
Fwiw, the benchmarks I have run show very similar performance to the older driver.
Regards, Dave
-----Original Message-----
From: "Ing. Martin Sramko"<martin@soltec.sk>
Sent: 20/08/05 11:07:08
To: "Dave Page"<dpage@vale-housing.co.uk>
Subject: Re: [ODBC] "Official" version
We are using psqlODBC 8.0.0102 and it is very stable to older versions...
New driver (libpq) seems stable, but so slow (why?) to ODBC 08.00.0102. I
can't find any reason for this. Can anyone help me? New driver has more
futures (SSL and so on), so we'll happy if we can use it.
Here is my system config:
MS WIN XP SP2 +
MS .NET Framework 1.1 SP1 +
MS VS 2003 +
psqlodbclibpq-08_01_0003
Database server PostgreSQL 8.0.3 on Fedora 4
My connection string (DSN less):
DRIVER={PostgreSQL};SERVER=x;DATABASE=x;UID=x;PASSWORD=x;PORT=5432;
A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_
----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: <pgsql-odbc@postgresql.org>
Sent: Friday, August 19, 2005 9:40 PM
Subject: [ODBC] "Official" version
>I think it's fairly safe to say that the new libpq version of psqlODBC
> is more stable than the previous release versions of the driver, and
> also now offers more features such as SSL, Kerberos authentication (has
> anyone tried this yet?), pgpass files and so on.
>
> In light of this, I think the libpq version should now take over as the
> official driver, and lose the 'libpq' suffix that was added for testing.
>
> If anyone has any strong objections, please shriek soon!!
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
