pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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