Re: Npsql is much faster than ODBC ?
| От | Ilan Volow |
|---|---|
| Тема | Re: Npsql is much faster than ODBC ? |
| Дата | |
| Msg-id | 7E7D4A6B-1F8A-40F5-BB1B-EC47EBA0BF42@clarux.com обсуждение исходный текст |
| Ответ на | Npsql is much faster than ODBC ? (一首诗 <newptcai@gmail.com>) |
| Список | pgsql-general |
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 tcptraffic between my program and the Postgresql database. I found thereare occasionally tcp re-transmission and that's why my porgram slowdown.But when I changed to npsql, the tcp traffic was cut off to only 1/4and there are much fewer re-transmission. I am not sure it's theproblem 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:"
В списке pgsql-general по дате отправления: