Postgres Pro
Downloads
Home   >   mailing lists

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

From Копыченко Павел
Subject Very slow perfomance for selecting big data resultsets.
Date
Msg-id 50C0DF35.50109@gmail.com
Whole thread Raw
Responses Re: Very slow perfomance for selecting big data resultsets.  (BGoebel <b.goebel@prisma-computer.de>)
List pgsql-odbc
Tree view 
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

pgsql-odbc by date:

Previous
From: JOUBERT Renaud
Date:
Subject: bug report on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 )
Next
From: BGoebel
Date:
Subject: Re: Very slow perfomance for selecting big data resultsets.