Keith Gray wrote:
>
> Hiroshi Inoue wrote:
> >
> > Keith Gray wrote:
> > >
> > > TOAST extensions. We have some documentation attached
> > > to fields which is up to 64kb.
> > >
> > > After upgrading the server I installed the current (7.1)
> > > ODBC driver for Win32.
> > >
> >
> > Is the version 7.01.0006 ?
>
> No... 7.01.0005
Please download the latest driver 7.01.0006.
Other drivers couldn't handle text fields > 8k.
>
> > > My write times are fairly slow. (significantly slower
> > > than 6.4/7.0)
>
> > Is the comparison for the < 8k data ?
>
> Without the large text attachment.
>
> > Is it as fast as 6.4/7.0 except concurrent write ?
>
> Not sure... lookups/queries are great (indexed and
> vacuum-analyzed) I think the write is slow... (and
> unsuccessful) because of a time-out.
Are you checking the 'Text as LongVarChar' driver option ?
regards,
Hiroshi Inoue