pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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 18:04:18 +0200
Message-ID: <5482c80a0706220904i6c9cc2a0x62af9703affc737e@mail.gmail.com> (raw)
In-Reply-To: <a5nn73lis68r6laumrk9jja36lvluf1c4a@4ax.com>
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>

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
>



view thread (27+ messages)  latest in thread

Message-ID: <5482c80a0706220904i6c9cc2a0x62af9703affc737e@mail.gmail.com>
Permalink:  ../5482c80a0706220904i6c9cc2a0x62af9703affc737e@mail.gmail.com/
Also on:    postgresql.org/message-id/5482c80a0706220904i6c9cc2a0x62af9703affc737e@mail.gmail.com

 · 

reply
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: <5482c80a0706220904i6c9cc2a0x62af9703affc737e@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