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

From Arnaud Lesauvage
Subject Re: Improve ODBC Throughput ?
Date
Msg-id 45387ACF.9010407@freesurf.fr
Whole thread Raw
In response to Re: Improve ODBC Throughput ?  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: Improve ODBC Throughput ?  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Hiroshi Inoue a écrit :
> 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 ?

TextAsLongVarchar=0 but the columns are VarChar in Access.


pgsql-odbc by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: Improve ODBC Throughput ?
Next
From: Hiroshi Inoue
Date:
Subject: Re: Improve ODBC Throughput ?