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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

