I might not go down the threading path at all, as in theory it wouldn't gain me that much - I'd still need to lock/unlock the database for each of the threads and I think the overhead of that plus the fact that it will have to wait for the other thread to do its stuff wouldn't gain me much if anything.
I found that my indexes are not used correctly, eventhough the SQL statements have no inequalities on the left and all fields are indexed. I guess I'll have to use the EXPLAIN to dig in and see what's wrong. > -----Original Message----- > From: Jason Hawryluk [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 27, 2007 5:40 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Questions on views > > I'd be interested in knowing the performance improvements > your able to achieve from threading. I would be in debt if > you'd post the results. > > cheers > > jason > > > > -----Message d'origine----- > De : Dennis Volodomanov [mailto:[EMAIL PROTECTED] > Envoye : mardi 27 mars 2007 04:35 > A : sqlite-users@sqlite.org > Objet : RE: [sqlite] Questions on views > > > Yes, threading is one option I'm testing and timing as well. > > > -----Original Message----- > > From: Joe Wilson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, March 27, 2007 12:29 PM > > To: sqlite-users@sqlite.org > > Subject: RE: [sqlite] Questions on views > > > > Assuming you're running on multi-core machines, spread the > work over a > > few threads/connections. > > > > --- Dennis Volodomanov <[EMAIL PROTECTED]> wrote: > > > Oops - that last sentence I wrote actually doesn't make > sense :) I > > > know what prepared statements are as I'm using them > (doh!). I might > > > have a problem that I need to add more WHERE conditions to > > those "basic" > > > statements, which wouldn't work probably with storing them, > > as I can't > > > possible know all possible combinations. Still - I'll give > > this some > > > thought to see if I can find something in this direction. > > > > > > > > > > > > ______________________________________________________________ > > ______________________ > > Never miss an email again! > > Yahoo! Toolbar alerts you the instant new Mail arrives. > > http://tools.search.yahoo.com/toolbar/features/mail/ > > > > -------------------------------------------------------------- > > --------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > -------------------------------------------------------------- > > --------------- > > > > > > -------------------------------------------------------------- > -------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > -------------- > - > > > > > > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
