[Mono-list] Data access delay using Npgsql

[Francisco Figueiredo Jr.]

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 
problem.

Regards,

Francisco Figueiredo Jr.