SLow work Poco::Data::ODBC with ODBCng driver

[EPConsult]

I developed server applicaton almoust fully based on Poco library. Application has modular structure based on Poco::SharedLibrary. There are HTTP server and several HTTP clients for exctraction some information from internet. Size of C++ code is above 500kb. All project's modules use PostgreSQL for store data. About 10 SQL queries executed in second in several threads, but execution time may be a half second for one query. Average 200-300 miliseconds on query. Database and server application runned on same computer(double dual core). OS is Fedore Core. ODBC driver is ODBCng.

Debug build of same project on Windows XP(single core P4 3000) with psqlODBC driver work faster ten times. Average 10-30 miliseconds on query.

May anybody help solve problem with query exection time on Fedore Core?
May be need to compile library and project special way?

If need additional information please ask me.

Sorry if my english not so good.

[alex]

> May anybody help solve problem with query exection time on Fedore Core?

> May be need to compile library and project special way?

Your problem is not likely POCO or Fedora related. My guess for culprit would be ODBCng which, although normally slightly faster then psqlODBC, in certain scenarios becomes inexplicably slow. I have experienced this by comparing the performance of the two against local and remote database. With a local database, ODBCng performed better. With the remote one, it was an order of magnitude slower. I did report this to the ODBCng author.

My advice is to stick w/ psqlODBC until ODBCng reaches production release.

hth

Alex

[EPConsult]

Thanks for your advice.
I'll try to use psqlODBC driver.

[EPConsult]

I use mysql database and ODBC for mysql driver.
Query execution time is 100-200 microseconds now.
Problem solved.
Thanks.