Re: [sqlite] Preventing Master Journal Files
Looks like Sqlite is not the right storage tool for your application since you don't want transactional integrity. How about something like Berkeley DB. Ken wrote: > Hello list, > > How do I prevent the creation of a journal file and a master journal file? I > need to be able to do this dynamically not just a compile time flag. > > The process does not need recovery as it is an all or none for some of the > DB's it creates. And is restarted from the beginning in the event of a crash. > > Thanks, > Ken > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Preventing Master Journal Files
Ken wrote: > Hello list, > > How do I prevent the creation of a journal file and a master journal > file? I need to be able to do this dynamically not just a compile > time flag. > I don't think you can do this. A journal file is always created except for in memory databases. You can change the synchronous pragma to off to get most of the speed benefits of operation without a journal, but the file will still be created. Execute "pragam synchronous = off" to disable file syncs, and when done, execute "pragma synchronous = full" to return to normal operation. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Preventing Master Journal Files
Hello list, How do I prevent the creation of a journal file and a master journal file? I need to be able to do this dynamically not just a compile time flag. The process does not need recovery as it is an all or none for some of the DB's it creates. And is restarted from the beginning in the event of a crash. Thanks, Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Preventing Master Journal Files.
How do I prevent the creation of a journal file and a master journal file? The process does not need recovery as it is an all or none. And is restarted from the beginning in the event of a crash. Thanks, Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users