From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Mihai Gheorghiu <tanhq@bigplanet.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: Win ODBC drivers for Postgres
Date: Wed, 7 Jun 2000 17:30:43 -0400
Message-ID: <001501bfd0c7$a3107fa0$6401a8c0@byron> (raw)
References: <000801bfd08e$54606480$c39c103f@new6>
Hey there partner,
To quote the immortal Butthead: "uhhhh....................., ok."
Seriously, I wonder how this "consultant" came up with this? Sounds
awefully generalized. I think I could say that line about anything,
including ODBC itself.
Also, many of the compromises of the ODBC driver are based on shortcomings
of the backend. Jeez, we still "simulate" a Prepared Statement because
there isn't one in the backend. Is the backend ever gonna have this?AFAIK,
the JDBC driver simulates the prepared statement also.
Some may remember the "declare/fetch" feature of the ODBC driver, that makes
use of postgres cursors. This feature was added to help with the network
bandwidth problem -- instead of getting the entire query result, it fetched
it in chunks when required.
Yeah, so maybe connection pooling would be nice, but most things use one or
two connections don't they? Do most processes keep asking odbc for a new
connection?
Byron
----- Original Message -----
From: Mihai Gheorghiu <tanhq@bigplanet.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Wednesday, June 07, 2000 10:36 AM
Subject: [INTERFACES] Win ODBC drivers for Postgres
> The following is a quote from a consultant's opinion on my intention to
> migrate to Postgresql.
> Quote:
> [ODBC public domain drivers] are immature, inefficient and are network
> bandwidth hogs. The public domain drivers don't support connection caching
> which reuses an existing database connection for same queries to reduce
the
> query result time.
> Unquote.
> Please comment.
>
> Best regards,
>
> Mihai
>
> PS See also pgsql-general for opinion on Postgres :-)
>
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-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, tanhq@bigplanet.com
Subject: Re: Win ODBC drivers for Postgres
In-Reply-To: <001501bfd0c7$a3107fa0$6401a8c0@byron>
* 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