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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-odbc by date

  From Date Subject
Next Message Zlatko Matic 2007-07-11 12:55:28 Re: odbc parameters
Previous Message A. Kretschmer 2007-07-11 12:31:54 Re: odbc parameters