Hi ,
I wish to use use sqlite for my embedded system. I need to maintain a database
of my current state. I basically have some daemons running , with only on
daemon being incharge of interfacing with the rest of the world and also
working on this db. I tried using sqlite , and as the no. of requests
increased my performance has gone down .
After going through the code and the locking protocol , I am thinking of
removing from the pager module the locking stuff , keeping the caching, and
journaling (for recovery) intact. This because I do not need concurrency
control only the ease of handling a database to a single file.
I would be grateful if anyone could give me some insight into these issues :
1) Can the journal and the caching be intact without the locking .
2) Is there any quick fix , without changing the code but having the same
effect.
3) Any other extra tips to improve performance in a single threaded
environment ??
Sincerely
Devesh Agrawal.
