Skip site navigation (1) Skip section navigation (2)

RE: slow performance postgres 7.0.3 and odbc

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'juerg(dot)rietmann(at)pup(dot)ch'" <juerg(dot)rietmann(at)pup(dot)ch>, pgsql-odbc(at)postgresql(dot)org
Subject: RE: slow performance postgres 7.0.3 and odbc
Date: 2001-06-15 13:48:14
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2C4C@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: juerg(dot)rietmann(at)pup(dot)ch [mailto:juerg(dot)rietmann(at)pup(dot)ch] 
> Sent: 15 June 2001 14:21
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] slow performance postgres 7.0.3 and odbc 
> 
> 
> Hello there
> 
> I just made a test creating 2495 records from a C++ prog. 
> into a postgres table. This took me around 4 minutes. Doing 
> the same against an access db takes 30 seconds ! I use 
> Version 6.50.00.00 from 04.02.2000.
> 
> What can I do to speed up the ODBC performance?

Check that ODBC Tracing is switched off in the ODBC driver manager, and that
the Debug Log (mylog) is switched off in the ODBC driver
(HKEY_LOCAL_MACHINE\Software\ODBC\odbcinst.ini\PostgreSQL\Debug = 0). The
Commlog option uin the driver could slow things as well but not even
remotely close to the amount the other two logs can slow the system down.

I would also consider getting the latest driver (07.01.0005) from
ftp://ftp.postgresql.org/pub/odbc/

HTH, Dave.

pgsql-odbc by date

Next:From: Christian BucanacDate: 2001-06-15 13:54:39
Subject: RE: slow performance postgres 7.0.3 and odbc
Previous:From: Javier YáñezDate: 2001-06-15 13:34:01
Subject: Re: slow performance postgres 7.0.3 and odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group