Skip site navigation (1) Skip section navigation (2)

Re: Data transfer very slow when connected via DSL

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: "Rainer Bauer" <usenet(at)munnin(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-22 09:37:40
Message-ID: 5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Rainer, but did you try initial query with FETCH_COUNT equal to 100?...

Rgds,
-Dimitri

On 6/22/07, Rainer Bauer <usenet(at)munnin(dot)com> wrote:
> Hello Dimitri,
>
> >Let's stay optimist - at least now you know the main source of your
> problem! :))
> >
> >Let's see now with CURSOR...
> >
> >Firstly try this:
> >munnin=>\timing
> >munnin=>\set FETCH_COUNT 1;
> >munnin=>select * from "tblItem";
> >
> >what's the time you see here? (I think your application is working in
> >this manner)
>
> That's it! It takes exactly 8 seconds like my program.
>
> I retrieve the data through a bound column:
> SELECT * FROM tblItem WHERE intItemIDCnt = ?
>
> After converting this to
> SELECT * FROM tblItem WHERE intItemIDCnt IN (...)
> the query is as fast as psql: 409ms
>
> So the problem is identified and the solution is to recode my application.
>
> Rainer
>
> PS: When enabling UseDeclareFetch as suggested by Tom then the runtime is
> still three times slower: 1192ms. But I guess that problem is for the ODBC
> list.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>

In response to

Responses

pgsql-performance by date

Next:From: Rainer BauerDate: 2007-06-22 10:02:15
Subject: Re: Data transfer very slow when connected via DSL
Previous:From: Rainer BauerDate: 2007-06-22 09:15:14
Subject: Re: Data transfer very slow when connected via DSL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group