Re: ODBC 7.1

Hiroshi Inoue <inoue@tpf.co.jp>

From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Keith Gray <keith@heart.com.au>
Cc: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Date: 2001-08-10T03:19:03Z
Lists: pgsql-sql
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