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.
>
I'd also check to see exactly what queries are being executed by turning
on query logging on the server. This might illuminate anything ADO is
doing that you didn't intend. Along the same lines, have you tried
running the same set of queries across the ADSL line using psql?
Cheers,
Eric