On Jan 22, 2013, at 5:54 PM, Keith Medcalf <kmedc...@dessus.com> wrote:
> I prefer the long-lived approach. Continuously re-initialization of the > connection on open, the need to re-read pages into the page cache > repetitively, and the subsequent discard of a nicely loaded page-cache on > connection close usually incurs non-trivial overhead. Thanks for this thoughtful response (you too, Simon). The page-cache argument is compelling. In my case, I only have one writer (I think!) during the big transaction, so a long-lived, singleton connection or WAL should work for me. I guess I would lean toward the former (KISS). -- Ward _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users