Skip site navigation (1) Skip section navigation (2)

Re: Improve ODBC Throughput ?

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 09:11:57
Message-ID: 453892DD.6000007@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Arnaud Lesauvage wrote:
> 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.

What is the type of the field > 10000 bytes in PG ?
If it's the text type, you have to turn on the Text As LongVarchar option.

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-10-20 09:18:08
Subject: Re: Improve ODBC Throughput ?
Previous:From: Ludek FinstrleDate: 2006-10-20 09:11:52
Subject: Re: Improve ODBC Throughput ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group