Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com> wrote:
> Hello,
>
> I'm working with an application that connects to a remote server database using "libpq" library over internet, but
makinga simple query is really slow even though I've done PostgreSQL Tunning and table being indexed, so I want to
know:
define slow.
>
> -Why is postgresql or libpq that slow when working over internet?
> -What else should I do to solve this issue in addition of postgresql tunning?
> -Why if I connect to the remote server desktop (using RDP or any Remote Desktop Application) and run the application
usingthe same internet connection, it runs really fast when making requests to postgresql; but if I run the application
locallyby connecting to the remote postgresql server through "libpq", it's really slow?.
Maybe DNS-Resolving - Problems...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°