Very slow perfomance for selecting big data resultsets.

[Копыченко Павел]

Hello.

I have a big data table. This table consist of 30 columns and 1000000
rows. I want to understand why the select of 100000 records in the
psqlODBC performed 60 seconds. When i do this with mySql ODBC this
operation perfomed 13 seconds. Are there any recommendations to speed
draver? Maybe have binary mode or any more settings?

Please help




--
Sent via pgsql-odbc mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

[BGoebel]

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.