On 18 August 2014 19:51, Igor Mironchik <igor.mironc...@gmail.com> wrote:
> Hi. > > Well, but with SQLite this approach works... > > -----Original Message----- > From: Sze Howe Koh > Sent: Monday, August 18, 2014 12:57 PM > To: Igor Mironchik > Subject: Re: [Interest] QThreadPool & writing to the DB > > Hi Igor, > > On 18 August 2014 14:26, Igor Mironchik <igor.mironc...@gmail.com> wrote: > > Hi. > > > > I want to move write to DB operation to another thread (from the GUI > > thread). And I implemented the following QRunnable: > > <snip> > > Is it OK to launch this runnable every time when I need to write to the > > log? > > <snip> > > And what if previous operation is still not finished and I will launch > > another? > > According to http://qt-project.org/doc/qt-5/threads-modules.html, your > queries must be made from the same thread which opened the database > connection. You cannot use QRunnable, because it doesn't let you > choose which thread to use. > > If you want to make queries in another thread, you must create a > QSqlDatabase in that thread, and associate every QSqlQuery with that > QSqlDatabase. Then, run every query from that same thread. > > See the QThread documentation for examples on how to set up your > thread: http://qt-project.org/doc/qt-5/QThread.html > > > Regards, > Sze-Howe > > _______________________________________________ > Interest mailing list > Interest@qt-project.org > http://lists.qt-project.org/mailman/listinfo/interest > btw , I have made an implementation that hold a thread and accept QRunnable on main thread then run it on the created thread. You may take it as a reference. https://github.com/benlau/dquest/blob/DEV_0_3/src/dqthread.cpp
_______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
