pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nicolas Huillard <nhuillard@ghs.fr>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: RE: Win ODBC drivers for Postgres
Date: Thu, 8 Jun 2000 10:05:22 +0200
Message-ID: <01BFD131.0FE4AA70@agen.int.ghs> (raw)

Yes, this seems very generalized... and sounds like a marketing speech. 
What is the background of this consultant ? Many times, this is only a 
matter of who pays him and what he really knows.

Nicolas Huillard

-----Message d'origine-----
De:	Byron Nikolaidis [SMTP:byron.nikolaidis@home.com]
Date:	mercredi 7 juin 2000 23:31
A:	Mihai Gheorghiu; pgsql-interfaces@postgresql.org
Objet:	Re: Win ODBC drivers for Postgres

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 :-)
>





view thread (6+ messages)  latest in thread

Message-ID: <01BFD131.0FE4AA70@agen.int.ghs>
Permalink:  ../01BFD131.0FE4AA70@agen.int.ghs/
Also on:    postgresql.org/message-id/01BFD131.0FE4AA70@agen.int.ghs

 · 

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-interfaces@postgresql.org
  Cc: nhuillard@ghs.fr
  Subject: RE: Win ODBC drivers for Postgres
  In-Reply-To: <01BFD131.0FE4AA70@agen.int.ghs>

* 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