"Evans, Mitchell" <[EMAIL PROTECTED]> wrote: > > We have a multithreaded application that uses a sqlite3 database for > asset tracking. I'm having some performance issues, and was wondering > how best to proceed. We're storing arbitrary blobs in the database, and > retrieving them in a standard manner (open, prep statement, > sqlite3_step). Our problem is that the sqlite3_step often takes up to > 1200 milliseconds to retrieve a blob. Granted, the blobs may be large, > but 1200 millis seems excessive. > > > > I'd like to narrow down what's causing the problem. Our queries, made > by a person very familiar with SQL and optimizing SQL, seem sane to me. > How do I narrow down if the time sink is: >
How large is the database file? How many rows? What is the schema? What query are you running? What OS are you running on? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
