Is there any reports/fix of this problem? Regards, Qingqing
On Fri, 2 Dec 2005, Josep Maria Pinyol Fontseca wrote: > > 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" <[EMAIL PROTECTED]> 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 *"? > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly