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

Re: Improve ODBC Throughput ?

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Improve ODBC Throughput ?
Date: 2006-10-19 21:38:15
Message-ID: 4537F047.6060901@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Arnaud Lesauvage wrote:
> Hi list !
>
> I mostly use my PostgreSQL as a backend DB with Access2000 frontends.
> The tables are linked via psqlODBC.
> The problem I have is that even though queries / views run very fast, 
> the data take a long time to arrive to the client.
> In the best situations, data is sent/received at ~500kB per second 
> (for instance, tables with only one column, which is a very large text 
> field >10.000 bytes per field).
>

How are you setting the "Text As LongVarchar" option ?
Are the columns text or memo using Access ?

regards,
Hiroshi Inoue


In response to

Responses

pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2006-10-20 00:46:53
Subject: Re: Improve ODBC Throughput ?
Previous:From: Hiroshi InoueDate: 2006-10-19 21:06:00
Subject: Re: Problem with error messages in VC++ 2005

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