Re: Improve ODBC Throughput ?

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

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