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
The machine was:
AMD X2 3800
2 Gig of Ram
PostgreSQL 8.1.4
Each test is ran in isolation, meaning that we create our connection,
run our cleanup, run our test and then disconnect. For each test, thus
no caching is occurring from PostgreSQL.
Anyway, these test clearly show that both ODBC drivers for PostgreSQL
have shown drastic improvement over the last 12 months.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
