[Mono-list] Data access delay using Npgsql

Francisco Figueiredo Jr. fxjrlists@yahoo.com.br
Wed, 11 Aug 2004 20:20:51 -0300

Reilly, Andrew wrote:
> Hi all,

Hi Reilly.

> 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
> be?

Are you using the machine name as the address of server?
I received some reports about that only in ms.net as you said. I still 
didn't find why it would be doing this delay. I some time noticed that 
name resolution with ms.net took some time.
Please, try passing the ip address and let me know if you still have the 


Francisco Figueiredo Jr.