Re: Npsql is much faster than ODBC ?

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:"