PostgreSQL's .NET provider runs slow as compared to the old ODBC provider.

Question

Why is it that the NPGSQL .NET Data Provider is slow when compared with the ODBC Provider? I have not tried NPGSQL 2.0 but I did worked with NPGSQL 1.0. It was very slow.

What are your experiences with NPGSQL 2.0?

Answer 1

Have had no problems with 2.0.1 and no noticeable difference in speed as opposed to ODBC (I heard Npgsql 1.0 wasnt great but havent used it). Have been using it with ADO .Net in Windows Forms and WPF apps no problem. One reccomendation when doing so: it is more robust to adopt the 'disconnected' paradigm used by ADO which is: Open a connection, do something, close a connection, rather than trying to use a single open connection for the lifetime of your app..

Also I find better to use this page than the pgFoundry one: http://npgsql.projects.postgresql.org/