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

Re: Data transfer very slow when connected via DSL

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-22 21:51:15
Message-ID: m6go735e6o8c0t6iv7q6ajv80p2u4qtqbg@4ax.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Tom TamulewiczDate: 2007-06-22 21:53:17
Subject: Re: Slow join query
Previous:From: Michael GlaesemannDate: 2007-06-22 21:30:56
Subject: Re: Slow join query

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