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

Re: odbc parameters

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: odbc parameters
Date: 2007-07-11 12:34:50
Message-ID: 20070711123450.GB25006@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
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.

I don't know how you transfer the data. So it's hard to answer.

> UpdatableCursors=1

Do you need this?

> LFConversion=1

Are you sure you want CR/LF conversion?

> Parse=1

Do you need parse statements? I think you don't need one of
UpdatableCursors or Parse at least.

> Fetch=100

You don't need specify this while you have UseDeclareFetch = 0

> RowVersioning=1

Do you need RowVersioning?

> Could you suggest what parameters values would yield best performance for 
> batch import to PostgreSQL?

Maybe this maybe someone suggest anothers. Let's experiment a little bit
yourself ;o)

Luf

In response to

pgsql-odbc by date

Next:From: Zlatko MaticDate: 2007-07-11 12:55:28
Subject: Re: odbc parameters
Previous:From: A. KretschmerDate: 2007-07-11 12:31:54
Subject: Re: odbc parameters

pgsql-general by date

Next:From: Fernando Madruga PinheiroDate: 2007-07-11 12:50:25
Subject: Strange round behaviour w/ more than 2 decimals
Previous:From: A. KretschmerDate: 2007-07-11 12:31:54
Subject: Re: odbc parameters

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