Re: Very slow perfomance for selecting big data resultsets.
Re: Very slow perfomance for selecting big data resultsets.
От:
BGoebel <b.goebel@prisma-computer.de>
Дата:
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.
Very slow perfomance for selecting big data resultsets.
От:
Копыченко Павел <t34box@gmail.com>
Дата:
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
