[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