Performance problems, when using ADO in threads
-
Hi, I've a problem when using Carlos Antollini ADO class in a "realtime" application. What I do is, that I call a thread that does all the database operations once every 10 minutes or so. But it seems like the database operations are not called asyncron, because the other threads within the application get freezed!? Would be great if you could give advice, otherwise I've to rewrite the whole DB part :sigh: Thanks Mario m_hThread = (HANDLE) _beginthreadex(NULL,0,_ThreadWriteToDB,this, 0,&nDummy); UINT WINAPI CDBManager::_ThreadWriteToDB(LPVOID pParam) { ASSERT(pParam); CDBManager *pDBMan = reinterpret_cast (pParam); DosSetPriority(PRTYS_THREAD, PRTYC_IDLETIME, THREAD_PRIORITY_IDLE, 0); pDBMan->m_Con.BeginTransaction(); ... ... ... pDBMan->m_Con.CommitTransaction(); // this thread has finished its work so we close the handle CloseHandle(pDBMan->m_hThread); }