From: Dimitri <dimitrik.fr@gmail.com>
To: Rainer Bauer <usenet@munnin.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Data transfer very slow when connected via DSL
Date: Fri, 22 Jun 2007 11:37:40 +0200
Message-ID: <5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com> (raw)
In-Reply-To: <9q3n73hcv5ekhl97spfj9bp6erq80j0241@4ax.com>
References: <s7tk73d57kvb3f4ph1kmkvhdfe0kak5a1r@4ax.com>
<16953.1182439969@sss.pgh.pa.us>
<a1el7395bhsv3n867kvefucj90l808hi54@4ax.com>
<5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com>
<b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com>
<5482c80a0706211538ka531c18gcf681cd5a68066b2@mail.gmail.com>
<9q3n73hcv5ekhl97spfj9bp6erq80j0241@4ax.com>
Rainer, but did you try initial query with FETCH_COUNT equal to 100?...
Rgds,
-Dimitri
On 6/22/07, Rainer Bauer <usenet@munnin.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dimitrik.fr@gmail.com, usenet@munnin.com
Subject: Re: Data transfer very slow when connected via DSL
In-Reply-To: <5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox