Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7A3HUP99963 for ; Thu, 9 Aug 2001 23:17:30 -0400 (EDT) (envelope-from Inoue@tpf.co.jp) Received: (qmail 6692 invoked from network); 10 Aug 2001 03:17:25 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 10 Aug 2001 03:17:25 -0000 Received: from tpf.co.jp ([126.0.1.68]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id MAA27567; Fri, 10 Aug 2001 12:17:24 +0900 (JST) Message-ID: <3B7352A7.EF2CD469@tpf.co.jp> Date: Fri, 10 Aug 2001 12:19:03 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Keith Gray CC: "pgsql-odbc@postgresql.org" Subject: Re: ODBC 7.1 References: <3B7347F7.AE509D5D@heart.com.au> <3B734DA7.29F0B8BE@tpf.co.jp> <3B734FCC.1C7C3FB2@heart.com.au> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/10 X-Sequence-Number: 766 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