Very slow perfomance for selecting big data resultsets.

From: Копыченко Павел <t34box(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Very slow perfomance for selecting big data resultsets.
Date: 2012-12-06 18:08:53
Message-ID: 50C0DF35.50109@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message BGoebel 2012-12-10 16:31:19 Re: Very slow perfomance for selecting big data resultsets.
Previous Message JOUBERT Renaud 2012-11-30 13:16:20 bug report on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 )