Re: odbc vs. libpq performance

Поиск
Список
Период
Сортировка
Искать
От
Heikki Linnakangas
Тема
Re: odbc vs. libpq performance
Дата
Msg-id
552F616E.3080508@iki.fi
Ответ на
Re: odbc vs. libpq performance (Vilches, Alejandro)
Список
Дерево обсуждения
odbc vs. libpq performance "Vilches, Alejandro" <alejandro.vilches@intel.com>
Re: odbc vs. libpq performance "Vilches, Alejandro" <alejandro.vilches@intel.com>
Re: odbc vs. libpq performance Heikki Linnakangas <hlinnaka@iki.fi>
Re: odbc vs. libpq performance "Vilches, Alejandro" <alejandro.vilches@intel.com>
Re: odbc vs. libpq performance "Vilches, Alejandro" <alejandro.vilches@intel.com>
Re: odbc vs. libpq performance Heikki Linnakangas <hlinnaka@iki.fi>
Re: odbc vs. libpq performance "Vilches, Alejandro" <alejandro.vilches@intel.com> 
On 04/16/2015 03:30 AM, Vilches, Alejandro wrote:
> I have a simple program that inserts data into a single table (see details below).  When I have the program connect to the DB via ODBC, performance is significantly slower compared to when I have it connect via libpq.  I was able to achieve ~1000 transactions per second using libpq, but only ~4 transactions per second using the ODBC driver.

I'd suggest setting log_min_duration_statement = 0 in the server's 
config file. Then repeat the test and look at the log file to see where 
the time is spent. If that gives no clue, I'm happy to take a look, if 
you can reproduce it with a small test program and post it to a list.

- Heikki
В списке pgsql-odbc по дате отправления
Предыдущее
От: Heikki Linnakangas
Дата:
Следующее
От: Devrim Gündüz
Дата:
FAQ