odbc driver/Npgsql comparison

odbc driver/Npgsql comparison

am 30.08.2007 18:42:59 von David Gardner

I was just wondering if anyone has done any performance comparisons
between the odbc driver and the Npgsql provider.
I searched through the archives, and couldn't find much. I have been
using the odbc driver for a while now, and am quite happy with it, I
usually end up writing some wrapper classes around ADODB connection and
recordset classes (in VB).

I will probably not port any existing code to the Npgsql provider, but I
am often asked to implement new views onto the existing pgsql backend,
and I am considering it for some new projects. I am interested in
hearing from people who have had success using it.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: odbc driver/Npgsql comparison

am 05.09.2007 16:55:18 von Joel Fradkin

We use npgsql for our .net stuff.
I have not done a comparison but it seems to work very well for our uses.
We use the odbc for our regular asp.

Joel Fradkin



Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305



jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.


-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of David Gardner
Sent: Thursday, August 30, 2007 12:43 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] odbc driver/Npgsql comparison

I was just wondering if anyone has done any performance comparisons
between the odbc driver and the Npgsql provider.
I searched through the archives, and couldn't find much. I have been
using the odbc driver for a while now, and am quite happy with it, I
usually end up writing some wrapper classes around ADODB connection and
recordset classes (in VB).

I will probably not port any existing code to the Npgsql provider, but I
am often asked to implement new views onto the existing pgsql backend,
and I am considering it for some new projects. I am interested in
hearing from people who have had success using it.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend