Re: Improve ODBC Throughput ?

Arnaud Lesauvage wrote:
> 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.

AFAIK the max text(VarChar) size in Access is 255.
Can you get the content of fields > 10000 bytes correctly
under the setting ?

regards,
Hiroshi Inoue