[Qt-interest] Driver not loaded...

Alex Strickland sscc at mweb.co.za
Mon Apr 4 21:40:49 CEST 2011


On 04/04/2011 17:01, Eric Clark wrote:

> Yes, I did read that, but I am technically not threading the inserts or
> selects. I am just putting them on a separate tread than the GUI so that
> the GUI does not lock up during the inserts. I am inserting a lot of
> data at the same time and it takes a very long time to do, so I need to

Apparently it takes a lot of time for good reasons. But, if your use 
case supports it, any or all of these may make sense for you:

     "PRAGMA synchronous = off"
     "PRAGMA journal_mode = off"
     "PRAGMA locking_mode = exclusive"

Also, putting writes within transactions makes things faster.

That may help?
-- 
Alex



More information about the Qt-interest-old mailing list