Re: remote connection problem - Mailing list pgsql-novice

From Ilija Vidoevski
Subject Re: remote connection problem
Date
Msg-id E7716F9C638A409088FC5F3BA0225636@fructal.com.mk
Whole thread Raw
In response to remote connection problem  ("Ilija Vidoevski" <ilija@fructal.com.mk>)
List pgsql-novice

Thank's Michael.

 

How can I be so blind. Connection is made.

 

But speed through LAN is disaster.

On the PC where postgresql server is installed, postgre is little slower then MS SqlSerever 2008 r2 express (same tables, same indexeses, same query).

 

But when I run app on client PC retrieving data from server is very, very slow. On server PC report finish  for 2-3 sec, but on client PC about 1 min.

 

On the server is also installed MS SqlSerever 2008 r2 express, and there is not great differences in speed to get data (from server or client PC). From server PC 1-2 sec and from client PC 2-4 sec.

 

 

Ilija

 

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: remote connection problem
Next
From: Valentin Gjorgjioski
Date:
Subject: Re: remote connection problem