Have you raised indices on the keys you use in your queries?
varunkumar 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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
