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" <jmpinyol@endepro.com> 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 *"?
> >