Re: PGDG ODBC, ODBCng, DBD::Pg

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
> Sent: 28 September 2006 23:26
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] PGDG ODBC, ODBCng, DBD::Pg
> 
> Hello,
> 
> I was running some basic benchmarks in comparison of the three
> aforementioned products. I thought I would drop a link here for people
> to compare:
> 
> http://projects.commandprompt.com/public/odbcng/wiki/Performance
> 
> One thing of note that is very positive IMHO is that PGDG ODBC and
> ODBCng both are showing that they can readily keep up with DBD::Pg in
> terms of basic performance.
> 
> Oddly, the ODBCng buffering option doesn't seem to offer as 
> much benefit
> as we thought it would but I need to test that with larger 
> (wider) data
> sets.
> 
> The versions tested were:
> 
> PGDG: 08.01.0200-2
> ODBCng: Rev 76
> DBD::Pg: 1.49

Any chance of running the same test again against psqlODBC 08.02.0100?
It's a totally different architecture to the 08.01 series. 

You might also try something like odbc-bench for some more realistic
tests.

Cheers, Dave.