Re: Slow query over ADSL Line

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: tc(at)geosys(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Slow query over ADSL Line
Date: 2006-03-06 14:16:49
Message-ID: 440C4451.8090403@pse-consulting.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Eric E 2006-03-06 14:48:27 Re: Slow query over ADSL Line
Previous Message Thomas Chabaud 2006-03-06 13:22:31 Re: Slow query over ADSL Line