DBI problems with Pg

hi,

I'm using postgresql v7.0.2 on Redhat Linux 6.2 with Perl's DBI
and DBD::Pg ... I've got a table ('annonces'), with 30 columns
and 100 000 rows .

The following script will work fine when launched on the Pg box;
but when launched from a remote computer, it will take hours to
execute, and finally hang the script. Though, we have a 100mbit
LAN. I've tried to put a limit in my select query, and then i get
a result -- it still takes a long time, yet.

Have anyone experimented the same behavior ?
Am i missing some FAQ or something ?

Thanks id advance.
Yohan Tordjman

My script:
--------------------------------------cut
use strict;
use DBI;

my $dbh = DBI->connect("dbi:Pg:dbname=xxxx;host=xxx", "user", "pass");
my $query = "SELECT * FROM annonces";

my $sth = $dbh->prepare($query);
$sth->execute;

while ( my @rows = $sth->fetchrow_array ) {

# statements.....

}

$sth->finish;
$dbh->disconnect;
--------------------------------------------cut