SQLite write (insert) performance doesn't seem very good to me so I'm
trying to find ways to improve it in my application. I had this idea
so I figured I'd run it past you folks who likely better know how the
db works under the hood.
did you wrap your inserts in a transaction?
I don't think I can do that because the inserts come in at random
intervals as they are generated by outside influences. I'm not just
doing an import of existing data as the data is created on the fly by
factors somewhat outside of my control. I tried to make an in-memory
temporary table and insert into that and periodically start a
transaction with an "insert into real_table select from memory_table"
thing in bulk, but that didn't seem to make a significant
difference. Perhaps I've got something else wrong.
Thanks for the suggestion.
l8r
Sean
