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

Re: odbc parameters

From: David Gardner <david(at)gardnerit(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: odbc parameters
Date: 2007-07-11 14:22:25
Message-ID: 4694E7A1.1040503@gardnerit.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Could you post what you are doing in Access? Are you just copy/pasting 
from a local table to a linked odbc table? Or are you executing insert 
statements in a VBA for loop, if so please post the VBA code?


There are some settings in the ODBC driver that can effect performance, 
but the types of SQL statements you are executing often have a much 
greater effect on overall performance.

Also if you could turn on the logging in the ODBC driver, often Access 
is executing queries on your behalf that you may be unaware of it.

Zlatko Matic wrote:
> Hello,
> 
> I use MS Access for data import. Access imports csv file, make some 
> calculation and transffers data to PostgreSQL.
> Unfortunately, it takes a lot of time to transfer data to PostgreSQL.
> My odbc settings are following:
> 
> 


-- 
David Gardner

In response to

pgsql-odbc by date

Next:From: Cláudia Macedo AmorimDate: 2007-07-12 20:27:13
Subject: Error retrieving records
Previous:From: A. KretschmerDate: 2007-07-11 13:46:38
Subject: Re: odbc parameters

pgsql-general by date

Next:From: Peter WiersigDate: 2007-07-11 15:01:25
Subject: Re: Strange round behaviour w/ more than 2 decimals
Previous:From: A. KretschmerDate: 2007-07-11 13:46:38
Subject: Re: odbc parameters

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