ODBC Driver performance
От | Josef Bicik |
---|---|
Тема | ODBC Driver performance |
Дата | |
Msg-id | 4BB35DC6.5050209@gmail.com обсуждение исходный текст |
Список | pgsql-odbc |
Hi, I wrote a C# (.NET v2) single-threaded console application in Microsoft Visual Studio 2008, which uses the PostgreSQL ANSI 8.03.04.00 ODBC driver to connect to PostgreSQL database running on a standalone server. The application retrieves raw data from the database, performs analysis and stores results to the database. Multiple instances of the application can be created at a time and run simultaneously. When multiple instances of the application are created on a multi-core machine the performance of the application is much slower than when the processes are executed on different nodes (e.g., 3 processes on 1 quad-core machine run approx. 25% slower than 3 processes on 3 quad-core machines). In case of 4 processes the difference is almost 50%. The CPU load when 3 processes are running on 1 quad-core machine was approx. 75% (which was as expected). Each process uses following ODBC connection string: Driver={PostgreSQL ANSI};Server=x;Port=5432;Database=x;Uid=x;Pwd=x;" I did not used any profiler but it seems that the overhead when multiple processes are running on 1 machine is in incorrect configuration of the ODBC driver or the driver itself. Any ideas what might be causing the slowdown? Thanks for your help. Best regards, Josef
В списке pgsql-odbc по дате отправления: