Re: Improve ODBC Throughput ?

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

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