Hi,
I wrote a Real Time logging app that insert logs from various Unix
machines in our lab into a sqlite Database.
The insertions are not batched as of now. Maybe that itself is an optimization.
1) Should I use a transaction even for a single record?
2) I open the DB, insert the record and close the DB for every record
inserted. What if the process crashed before I closed the DB. Would
the DB get locked? If so how do I unlock it?
3) I got the app running over the last week and noticed it worked well
till it reached 6 million records. The DB then suddenly got locked w/o
the app crashing or anything. I then killed the app and could run
queries via the Command Line tool. Restarting the app locked the DB
again.
Any ideas? :-(
Thanks!
