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