Re: Npsql is much faster than ODBC ?

[Ilan Volow <listboy@xxxxxxxxxx>]

I've never used Npsql and I'm not a C# developer (so take this response with more than a few grains of salt) but from what I remember reading somewhere, Npsql implements postgres protocols natively, with the protocol handling done directly in C# and getting the raw data without going through any other software layers (such as other interfaces that wrap libpq). There are several layers of software between an application speaking ODBC and a PostgreSQL server, and you'll probably get a speed hit going through each of those layers. 

-- Ilan

On Nov 5, 2007, at 10:42 AM, 一首诗 wrote:

Hi all,

Recently I found my C/S program becomes slow.  So I analysed the tcp

traffic between my program and the Postgresql database.  I found there

are occasionally tcp re-transmission and that's why my porgram slow

down.

But when I changed to npsql,  the tcp traffic was cut off to only 1/4

and there are much fewer re-transmission.  I am not sure it's the

problem of odbc or it's because that I am using odbc correctly.

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Ilan Volow

"Implicit code is inherently evil, and here's the reason why:"