On 08/18/2014 07:51 AM, Igor Mironchik wrote: > Hi. > > Well, but with SQLite this approach works...
Which goes to show you just how sadistic multi-threading can be. > > -----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 > _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
