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] > ----------------------------------------------------------------------------- > -- View this message in context: http://www.nabble.com/sqlite3_exec-function-error%3Adatabase-is-locked-tf4612181.html#a13190985 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
