Re: Data transfer very slow when connected via DSL - Mailing list pgsql-performance

From Rainer Bauer
Subject Re: Data transfer very slow when connected via DSL
Date
Msg-id m6go735e6o8c0t6iv7q6ajv80p2u4qtqbg@4ax.com
Whole thread Raw
In response to Re: Data transfer very slow when connected via DSL  (Dimitri <dimitrik.fr@gmail.com>)
List pgsql-performance
Hello Dimitri,

>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...

But that is only for bulk fetching with SQLExtendedFetch() and does not work
for my case with a single bound column where each tuple is retrived
individually by calling SQLFetch().
See <http://msdn2.microsoft.com/en-us/library/ms713591.aspx>

Rainer

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Slow join query
Next
From: "Tom Tamulewicz"
Date:
Subject: Re: Slow join query