Are you using any BLOBs in your table?. More often than not it will be your query which will have direct impact on the performance. I suggest you to check that appropriate columns have been indexed and are used in right manner as specified in the SQLite documentation or mailing list with subject " How does SQLite choose the index?"
Cheers, Bharath On 10/13/07 9:34 PM, "varunkumar" <[EMAIL PROTECTED]> wrote: > > i have 40 columns table in my database. now my database size is 23MB . > untill now my database has 78752 rows(records). when i am query database it > is taking 10 seconds of time . my database performance is degrading. > i want to improve my database performance what should i do to improve > performance. this report generating time depends on what parameters . is it > depend on number of rows and size of the database > > > > > Richard Klein-3 wrote: >> >>> varunkumar <[EMAIL PROTECTED]> wrote: >>>> so two different processes cannot access the database at a time >>>> >>> >>> One process cannot access the database at the same instant >>> in time that another process is modifying the database. >>> >>> -- >>> D. Richard Hipp <[EMAIL PROTECTED]> >> >> To clarify further: Process A and process B can both have >> the same database *open* at the same time. >> >> However, if process A tries to access (read or write) the >> database while process B is modifying (writing) it, then >> process A will get a SQLITE_BUSY error code returned to it. >> >> Process A should be prepared to handle this SQLITE_BUSY >> error. Typically he will want to sleep for a little while, >> and then try again. >> >> - Richard Klein >> >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- >> ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
