Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application - Mailing list pgsql-performance

From Eric Lauzon
Subject Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
Date
Msg-id F7B73864DD39FA40B6C56B3CE0D4D1CB6344E3@asdc003.abovesecurite.lan
Whole thread Raw
In response to PERFORMANCE ISSUE ODBC x LIBPQ C++ Application  (grupos <grupos@carvalhaes.net>)
List pgsql-performance
i would take a peek at psqlodbc-8.0 drivers ..
i wouldn't battle with other version you might find such as (unixodbc
ones)


-elz


> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> Merlin Moncure
> Sent: 27 juin 2005 10:29
> To: grupos
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
>
> > Hi !
> >
> > My company is evaluating to compatibilizate our system (developed in
> > C++) to PostgreSQL.
> >
> > Our programmer made a lot of tests and he informed me that the
> > performance using ODBC is very similar than using libpq, even with a
> big
> > number of simultaneous connections/queries. Of course that
> for us is
> > simpler use ODBC because will be easier to maintan as we already
> support
> > a lot of other databases using ODBC (MySQL, DB2, etc).
> >
> > Someone already had this experience? What are the key
> benefits using
> > libpq insted of ODBC ?
> >
> > Our application have a heavy load and around 150 concorrent users.
>
> The ODBC driver for postgresql implements its own protocol stack.
> Unfortunately, it is still on protocol revision 2 (out of 3).
>  Also, IMO libpq is a little better tested and durable than
> the odbc driver.  This naturally follows from the fact that
> libpq is more widely used and more actively developed than odbc.
>
> If you are heavily C++ invested you can consider wrapping
> libpq yourself if you want absolute maximum performance.  If
> you happen to be developing on Borland platform give strong
> consideration to Zeos connection library which is very well
> designed (it wraps libpq).
>
> You might want to consider posting your question to the odbc list.
>
> Merlin
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
Next
From: "Merlin Moncure"
Date:
Subject: Re: [HACKERS] How two perform TPC-H test on postgresql-8.0.2