Re: Improve ODBC Throughput ?

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