Re: Very slow perfomance for selecting big data resultsets. - Mailing list pgsql-odbc

From BGoebel
Subject Re: Very slow perfomance for selecting big data resultsets.
Date
Msg-id 1355157079562-5735930.post@n5.nabble.com
Whole thread Raw
In response to Very slow perfomance for selecting big data resultsets.  (Копыченко Павел <t34box@gmail.com>)
List 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.


pgsql-odbc by date:

Previous
From: Копыченко Павел
Date:
Subject: Very slow perfomance for selecting big data resultsets.
Next
From: Dave Manginelli
Date:
Subject: Connection dialog behavior of ODBC driver psqlODBC 9.01.0200 vs 8.x on Win XP