[Qt-interest] Driver not loaded...

[Eric Clark]

> -----Original Message-----
> From: qt-interest-bounces+eclark=ara.com at qt.nokia.com [mailto:qt-
> interest-bounces+eclark=ara.com at qt.nokia.com] On Behalf Of Alex
> Strickland
> Sent: Monday, April 04, 2011 2:41 PM
> To: qt-interest at qt.nokia.com
> Subject: Re: [Qt-interest] Driver not loaded...
> 
> 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

Yes it is for good reason. I have a little over 25000 rows of data being inserted into the database and it takes a really long time to do so.

> supports it, any or all of these may make sense for you:
> 
>      "PRAGMA synchronous = off"
>      "PRAGMA journal_mode = off"
>      "PRAGMA locking_mode = exclusive"

I am not familiar with any of these or even how to set them. Is there any chance that you could point me in the right direction to look into what these options do and how to set them?

> 
> Also, putting writes within transactions makes things faster.

I will look into this. It has been a very long time since I did database stuff, so I am kind of brushing up on my skills right now. I did, however, think to use batched inserts because I thought that might speed things up, but according to the documentation, SqLite does not support batched inserts, so it is kind of pointless for me to batch the queries. But, I will certainly look into what I can do with transactions. Thank You!

> 
> That may help?
> --
> Alex
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at qt.nokia.com
> http://lists.qt.nokia.com/mailman/listinfo/qt-interest