Re: Network permormance under windows

Yes, with psql, pgAdminIII and our application with ODBC I experiment 
the same situation... the sentences that I execute are like "select * 
..." or similar like this.


Qingqing Zhou wrote:

>"Josep Maria Pinyol Fontseca"  wrote
>  
>
>>When we select all data in local machine, we obtain results in 2-3 seconds 
>>aprox. In remote connections:
>>
>>Postgresql 7.1 usign pgAdminII:
>>Network traffic generated with remote applications is about 77-80% in a 
>>10Mb connection.
>>6 seconds aprox.
>>
>>Postgresql 8.1 usign pgAdminIII:
>>Network traffic generated with remote applications is about 2-4% in a 10Mb 
>>connection.
>>12 seconds or more...
>>
>>    
>>
>
>Have you tried to use psql? And how you "select all data" - by "select 
>count(*)"  or "select *"?
>
>Regards,
>Qingqing 
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>  
>


-- 
Josep Maria Pinyol i Fontseca
Responsable àrea de programació

ENDEPRO - Enginyeria de programari
Passeig Anselm Clavé, 19 Bx. 08263 Callús (Barcelona)
Tel. +34 936930018 - Mob. +34 600310755 - Fax. +34 938361994
jmpinyol@endepro.com - http://www.endepro.com


Aquest missatge i els documents en el seu cas adjunts,
es dirigeixen exclusivament al seu destinatari i poden contenir
informació reservada i/o CONFIDENCIAL, us del qual no està
autoritzat ni la divulgació del mateix, prohibit per la legislació
vigent (Llei 32/2002 SSI-CE). Si ha rebut aquest missatge per error,
li demanem que ens ho comuniqui immediatament per la mateixa via o
bé per telèfon (+34936930018) i procedeixi a la seva destrucció.
Aquest e-mail no podrà considerar-se SPAM.

Este mensaje, y los documentos en su caso anexos,
se dirigen exclusivamente a su destinatario y pueden contener
información reservada y/o CONFIDENCIAL cuyo uso no
autorizado o divulgación está prohibida por la legislación
vigente (Ley 32/2002 SSI-CE). Si ha recibido este mensaje por error,
le rogamos que nos lo comunique inmediatamente por esta misma vía o
por teléfono (+34936930018) y proceda a su destrucción.
Este e-mail no podrá considerarse SPAM.

This message and the enclosed documents are directed exclusively
to its receiver and can contain reserved and/or confidential
information, from which use isn’t allowed its divulgation, forbidden
by the current legislation (Law 32/2002 SSI-CE). If you have received
this message by mistake, we kindly ask you to communicate it to us
right away by the same way or by phone (+34936930018) and destruct it.
This e-mail can’t be considered as SPAM.