On 1/25/16, Stephen Chrzanowski <pontiac76 at gmail.com> wrote: > > You also have to look at balance across many millions (or is it billions?) > of devices out there that use SQLite for their primary operations.
Billions and billions. > Slapping a serious performance decrease on devices where time and > performance is essential BY DEFAULT seems a little strict. And all at the > cost of one transaction? To some, maybe a worthwhile trade off, sure, but > I'm not sure I'm be overly outraged if my wifes music box (iPod) suddenly > had to recompile its music list. I don't think it is even that serious. This problem is that if you (for example) set a new bookmark on your browser just as the cat is tripping over the power cord, then after reboot the bookmark disappears. The bookmark database is still completely intact - it just went backwards in time a little. -- D. Richard Hipp drh at sqlite.org
