Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 791429FC20A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 22 Jun 2007 13:04:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 11305-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 22 Jun 2007 13:04:21 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.224])
	by postgresql.org (Postfix) with ESMTP id 001609FB807
	for <pgsql-performance@postgresql.org>;
	Fri, 22 Jun 2007 13:04:20 -0300 (ADT)
Received: by wx-out-0506.google.com with SMTP id s16so802705wxc
	for <pgsql-performance@postgresql.org>;
	Fri, 22 Jun 2007 09:04:20 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=lipysWXmkhm8aVztO7uhqJf62CcYcJi0VLUnL5iEd+mwA8M16I2jgmQe2umqNchcLiVkyouzQ7a5SJtOL++HHo2Nx0H9vntc0N24YLlsf3PGeCk10ynweOmIktalvL35jcgh3VWiwOjtW7fwNmP6ZDHVeX2EujiNBwKfhG20118=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=EqdyWUYHFmNxHMGjC4sYmYli/CEpCv0dV/M/2xWobRAKQcuCVYkMf6FRqkFSLTsT9XJ43Fkr+sNAHLkT1pi+ACRnBQnWJxJqbN4tQssihZZj5xoFcIEyGI6KFiV8ftm/jOm7iUXxHNDNjwF7mG7qAksTZDQb9y54NHvCn41p0iY=
Received: by 10.70.39.5 with SMTP id m5mr5062892wxm.1182528259027;
	Fri, 22 Jun 2007 09:04:19 -0700 (PDT)
Received: by 10.70.90.7 with HTTP; Fri, 22 Jun 2007 09:04:18 -0700 (PDT)
Message-ID: <5482c80a0706220904i6c9cc2a0x62af9703affc737e@mail.gmail.com>
Date: Fri, 22 Jun 2007 18:04:18 +0200
From: Dimitri <dimitrik.fr@gmail.com>
To: "Rainer Bauer" <usenet@munnin.com>
Subject: Re: Data transfer very slow when connected via DSL
Cc: pgsql-performance@postgresql.org
In-Reply-To: <a5nn73lis68r6laumrk9jja36lvluf1c4a@4ax.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com>
	<b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com>
	<5482c80a0706211538ka531c18gcf681cd5a68066b2@mail.gmail.com>
	<9q3n73hcv5ekhl97spfj9bp6erq80j0241@4ax.com>
	<5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com>
	<5h7n73hqcac6ksuv23auf691mcmagokalr@4ax.com>
	<5482c80a0706220524x6ebe70d8ga80f30bb20bd97d5@mail.gmail.com>
	<slin731d2jkblh46vovha792eeuhfir2lk@4ax.com>
	<467BD9B2.5010208@commandprompt.com>
	<a5nn73lis68r6laumrk9jja36lvluf1c4a@4ax.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/542
X-Sequence-Number: 25575

Rainer, seeking psqlODBC code source it seems to work in similar way
and have an option "SQL_ROWSET_SIZE" to execute FETCH query in the
same way as "FETCH_COUNT" in psql. Try to set it to 100 and let's see
if it'll be better...

Rgds,
-Dimitri

On 6/22/07, Rainer Bauer <usenet@munnin.com> wrote:
> Hello Joshua,
>
> >That opens up some questions. What ODBC driver are you using (with exact
> >version please).
>
> psqlODBC 8.2.4.2 (build locally).
>
> I have restored the 8.2.4.0 from the official msi installer, but the results
> are the same.
>
> Rainer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>