Npsql is much faster than ODBC ?

From: 一首诗 <newptcai(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Npsql is much faster than ODBC ?
Date: 2007-11-05 15:42:01
Message-ID: 1194277321.151897.145630@e9g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2007-11-05 15:59:01 Re: COPY ... FROM and index usage
Previous Message Rainer Bauer 2007-11-05 15:17:28 Re: Copy the database..