pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Maier <am@fx.ro>
To: pgsql-performance@postgresql.org
Subject: horrible performance when trying to connect to PostgreSQL using ODBC
Date: Thu, 06 Nov 2003 10:43:39 +0200
Message-ID: <3FAA09BB.6050705@fx.ro> (raw)

Hello guys !

I am trying to connect to pgsql using ODBC from Visual Objects
(for the ones who don't know what is Visual Objects, it's an IDE
with its own object-oriented language made by Computer Associates.
VO's roots are related to Clipper. ).

The time it takes to get the list of the tables, and then to get the 
data and display it way too long. It took more than 16 seconds to
connect, get 200 records and print them on the console.

I know for sure that it's not pgsql's fault: with a small c program
that uses libpq i got the same data instantaneously. Also, it looks
like it's not VO's fault (i know that there are people who used VO
against big databases). So, the problem must be related to the ODBC
(the pgsql driver or something else?).

Anyway, i've tried to open the same table from MSAccess, and the
performance was even worse. Just an example: for going from one record
to the next one it lasts about 4-5 seconds.

The machine is a Pentium2 266mhz (128mb) laptop running windows NT.

Today, I have tried to access pgsql from MSAccess at work.  It worked 
very fast. I've used the same ODBC drivers,   but the machine is
faster (p4 2.4ghz), has more memory, and the OS is windows 2000.
But it is hard for me to believe that a Pentium2 machine with 128mb RAM
can't handle 200 records !

I begin to think that there is something fishy about the ODBC
support installed on the laptop (i have recently "inherited" the
laptop from someone else, and i haven't reinstalled the os ).

What do you guys think?   what could be done to make things go
faster?


I have also two more questions. After installing the pgsql odbc
drivers, there are 3 drivers that appear:
"PostgreSQL", "POstgreSQL legacy" and "PostgreSQL unicode".
What's the difference between "PostgreSQL" and "PostgreSQL lecacy"?
Are there any options of the odbc driver that could cause a
performance boost?

Thanks you,

Adrian Maier













view thread (2+ messages)  latest in thread

Message-ID: <3FAA09BB.6050705@fx.ro>
Permalink:  ../3FAA09BB.6050705@fx.ro/
Also on:    postgresql.org/message-id/3FAA09BB.6050705@fx.ro

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: am@fx.ro
  Subject: Re: horrible performance when trying to connect to PostgreSQL using ODBC
  In-Reply-To: <3FAA09BB.6050705@fx.ro>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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