On Wed, Mar 31, 2010 at 06:16:13PM -0700, Jim "Jed" Dodgen wrote: > On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski > >> (3) Each table and index is in a > >> separate file so your "database" was a directory full of files instead > >> of a single file > > > > This one is not a problem. Actually I don't see how 1 file is better > > than 1 directory. [...] > > Two reasons I prefer the single file approach: > > 1. Simpler copy, tables and indexes don't get lost or mismatched. > > 2. fewer handles to open a database. Lower overhead.
3. One fsync() vs. many (or a full sync()). Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users