[Mono-list] Data access delay using Npgsql

Reilly, Andrew Andrew.Reilly@luht.scot.nhs.uk
Wed, 11 Aug 2004 11:06:36 +0100

Hi all,

I've been experimenting with accessing a PostgreSQL database using Npgsql,
but have come across a problem.

Whenever I open a new NpgsqlConnection under the MS .NET runtime there is
always a short delay of a few seconds, presumably while the client
authenticates with the server. However, when the same program is run under
mono the delay is almost imperceptible. This is frustrating because I tend
to develop under VS.NET then distribute using mono.

I'm running mono 1.0.1 with Npgsql 0.6 and the server is PostgreSQL 7.4.3.
I've tried turning on logging support in Npgsql but it doesn't report
anything relevant: the log starts from when the connection is actually
established any everything works quickly after that. I've also tried
relaxing the authentication settings of the database but this has no effect.

Does anyone have any suggestions as to what the cause of the problem might

Best wishes,


The information contained in this message may be confidential or legally privileged and is intended for the addressee only, If you have received this message in error or there are any problems please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden.