> > > Since PERSIST is likely to be faster than DELETE on > most platforms, is there ever a reason *not* to use > it? >
In PERSIST mode, you have two files associated with your database instead of one. Whenever you move, copy, or rename the database file you *must* also move, copy or rename the journal file to prevent database corruption. The persistent journal file uses disk space that might otherwise have been returned to the operating system and made available to other programs. We have not tested the robustness and power-loss survivability of PERSIST mode nearly as carefully as we have the existing DELETE mode. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
