Re: Improve ODBC Throughput ?

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.