Overview
Features
Download
Documentation
Community
Add-Ons & Services

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

Please post support and help requests here.

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

Postby EPConsult » 11 Mar 2008, 20:33

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.
EPConsult
 
Posts: 3
Joined: 11 Mar 2008, 08:26

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

Postby alex » 11 Mar 2008, 22:38

> 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
alex
 
Posts: 1047
Joined: 11 Jul 2006, 16:27
Location: United_States

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

Postby EPConsult » 12 Mar 2008, 06:20

Thanks for your advice.
I'll try to use psqlODBC driver.
EPConsult
 
Posts: 3
Joined: 11 Mar 2008, 08:26

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

Postby EPConsult » 13 Mar 2008, 13:23

I use mysql database and ODBC for mysql driver.
Query execution time is 100-200 microseconds now.
Problem solved.
Thanks.
EPConsult
 
Posts: 3
Joined: 11 Mar 2008, 08:26


Return to Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron