Re: Improve ODBC Throughput ? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Improve ODBC Throughput ?
Date
Msg-id 4537F047.6060901@tpf.co.jp
Whole thread Raw
In response to Improve ODBC Throughput ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: Improve ODBC Throughput ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
List 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


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Problem with error messages in VC++ 2005
Next
From: Richard Broersma Jr
Date:
Subject: Re: Improve ODBC Throughput ?