Re: Very slow perfomance for selecting big data resultsets.

From: BGoebel <b(dot)goebel(at)prisma-computer(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Very slow perfomance for selecting big data resultsets.
Date: 2012-12-10 16:31:19
Message-ID: 1355157079562-5735930.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello

Would you try to execute your SELECT within pgAdmin?

If performance is much better now, take a look at my post
http://postgresql.1045698.n5.nabble.com/Result-Set-over-Network-Question-tt5682480.html#a5708971

Best performance you will get by using COPY
http://www.postgresql.org/docs/9.2/static/sql-copy.html
and read the resultset via a text file.

best regards
BGoebel

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Very-slow-perfomance-for-selecting-big-data-resultsets-tp5735505p5735930.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Manginelli 2012-12-11 15:10:26 Connection dialog behavior of ODBC driver psqlODBC 9.01.0200 vs 8.x on Win XP
Previous Message Копыченко Павел 2012-12-06 18:08:53 Very slow perfomance for selecting big data resultsets.