Re: Improve ODBC Throughput ?

Hiroshi Inoue a écrit :
> 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 ?

In fact, the only text fields I have are memo in access, but
I have very fex text fields. Most of them are character
varying of length <= 254.