| From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Improve ODBC Throughput ? |
| Date: | 2006-10-20 08:07:39 |
| Message-ID: | 453883CB.8080601@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Lesauvage | 2006-10-20 08:49:34 | Re: Improve ODBC Throughput ? |
| Previous Message | Ludek Finstrle | 2006-10-20 07:54:57 | Re: Improve ODBC Throughput ? |