[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 Eric Clark
> Sent: Tuesday, April 05, 2011 10:19 AM
> To: Qt Interest (qt-interest at trolltech.com)
> Subject: Re: [Qt-interest] Driver not loaded...
> 
> 
> 
> > -----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?

I found the documentation on the pragma commands. Thank you for your insight!

> 
> >
> > 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
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at qt.nokia.com
> http://lists.qt.nokia.com/mailman/listinfo/qt-interest