Re: Slow query over ADSL Line - Mailing list pgsql-odbc

From Andreas Pflug
Subject Re: Slow query over ADSL Line
Date
Msg-id 440C4451.8090403@pse-consulting.de
Whole thread Raw
In response to Re: Slow query over ADSL Line  (Thomas Chabaud <tc@geosys.com>)
List pgsql-odbc
Thomas Chabaud wrote:
> Philippe Lang a écrit :
>
>> Hi,
>>
>> How fast to you get the results of your 300 queries on the LAN?
>> Have you maybe tried sniffing the network, for example with tcpdump?
>>
>> Philippe
>>
>
> On the lan I fetch the result in approximatively 1.5s (for all queries)
> I will try to sniff the network to see if there's something wrong.
> Thanks for your advice.

Maybe a latency problem. Check if your roundtrip ping times are
consistent when changing packet sizes.

Regards,
Andreas

pgsql-odbc by date:

Previous
From: Thomas Chabaud
Date:
Subject: Re: Slow query over ADSL Line
Next
From: Eric E
Date:
Subject: Re: Slow query over ADSL Line