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?
Ilan Volow
"Implicit code is inherently evil, and here's the reason why:"