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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Bucanac | 2001-06-15 13:54:39 | RE: slow performance postgres 7.0.3 and odbc |
Previous Message | Javier Yáñez | 2001-06-15 13:34:01 | Re: slow performance postgres 7.0.3 and odbc |