pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ODBC 7.1 5+ messages / 2 participants [nested] [flat]
* ODBC 7.1 @ 2001-08-10 02:33 Keith Gray <keith@heart.com.au> 2001-08-10 02:57 ` Re: [SQL] ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> 0 siblings, 1 reply; 5+ messages in thread From: Keith Gray @ 2001-08-10 02:33 UTC (permalink / raw) To: pgsql-sql Greetings All, Is this the correct forum to discuss ODBC driver issues? I have a Linux/PostgreSQL server which has been upgraded to run 7.1 - the main reason was to be able to use the 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. It now seems that concurrent table writes are limited? My write times are fairly slow. (significantly slower than 6.4/7.0) Some tables which are updated simultaneously - like sales and general ledger are not staying in synch. Any suggestions would be welcomed (including upgrades) -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] ODBC 7.1 2001-08-10 02:33 ODBC 7.1 Keith Gray <keith@heart.com.au> @ 2001-08-10 02:57 ` Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-10 03:06 ` Re: ODBC 7.1 Keith Gray <keith@heart.com.au> 0 siblings, 1 reply; 5+ messages in thread From: Hiroshi Inoue @ 2001-08-10 02:57 UTC (permalink / raw) To: Keith Gray <keith@heart.com.au>; +Cc: pgsql-sql; pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org> Keith Gray wrote: > > Greetings All, > > Is this the correct forum to discuss ODBC driver issues? > No, pgsql-odbc is the right forum. > I have a Linux/PostgreSQL server which has been upgraded > to run 7.1 - the main reason was to be able to use the > 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 ? > It now seems that concurrent table writes are limited? > > My write times are fairly slow. (significantly slower > than 6.4/7.0) > Is the comparison for the < 8k data ? Is it as fast as 6.4/7.0 except concurrent write ? regards, Hiroshi Inoue ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC 7.1 2001-08-10 02:33 ODBC 7.1 Keith Gray <keith@heart.com.au> 2001-08-10 02:57 ` Re: [SQL] ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> @ 2001-08-10 03:06 ` Keith Gray <keith@heart.com.au> 2001-08-10 03:19 ` Re: ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> 0 siblings, 1 reply; 5+ messages in thread From: Keith Gray @ 2001-08-10 03:06 UTC (permalink / raw) To: Hiroshi Inoue <Inoue@tpf.co.jp>; +Cc: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org> 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 > > 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. -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC 7.1 2001-08-10 02:33 ODBC 7.1 Keith Gray <keith@heart.com.au> 2001-08-10 02:57 ` Re: [SQL] ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-10 03:06 ` Re: ODBC 7.1 Keith Gray <keith@heart.com.au> @ 2001-08-10 03:19 ` Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-14 02:14 ` Re: ODBC 7.1 Keith Gray <keith@heart.com.au> 0 siblings, 1 reply; 5+ messages in thread From: Hiroshi Inoue @ 2001-08-10 03:19 UTC (permalink / raw) To: Keith Gray <keith@heart.com.au>; +Cc: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC 7.1 2001-08-10 02:33 ODBC 7.1 Keith Gray <keith@heart.com.au> 2001-08-10 02:57 ` Re: [SQL] ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-10 03:06 ` Re: ODBC 7.1 Keith Gray <keith@heart.com.au> 2001-08-10 03:19 ` Re: ODBC 7.1 Hiroshi Inoue <Inoue@tpf.co.jp> @ 2001-08-14 02:14 ` Keith Gray <keith@heart.com.au> 0 siblings, 0 replies; 5+ messages in thread From: Keith Gray @ 2001-08-14 02:14 UTC (permalink / raw) To: Hiroshi Inoue <Inoue@tpf.co.jp>; +Cc: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org> Hiroshi Inoue wrote: > > Keith Gray wrote: > > > Please download the latest driver 7.01.0006. > Other drivers couldn't handle text fields > 8k. Done that now... > Are you checking the 'Text as LongVarChar' driver option ? Yes. It doesn't look like an ODBC issue now... I have tried all ODBC drivers 6.4, 7.0 and 7.1 with less than 8kb fields and they all seem to have this same problem with timeout. To me this seems like a 7.1 database issue we didn't seem to have with 6.4 and 7.0 Not sure what the timeout is, but I assume a lock condition. -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-08-14 02:14 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-08-10 02:33 ODBC 7.1 Keith Gray <keith@heart.com.au> 2001-08-10 02:57 ` Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-10 03:06 ` Keith Gray <keith@heart.com.au> 2001-08-10 03:19 ` Hiroshi Inoue <Inoue@tpf.co.jp> 2001-08-14 02:14 ` Keith Gray <keith@heart.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox