Very slow perfomance for selecting big data resultsets.

Поиск
Список
Период
Сортировка
От Копыченко Павел
Тема Very slow perfomance for selecting big data resultsets.
Дата
Msg-id 50C0DF35.50109@gmail.com
обсуждение исходный текст
Ответы Re: Very slow perfomance for selecting big data resultsets.
Список 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




В списке pgsql-odbc по дате отправления: