On 14 Jul 2010, at 5:02pm, Black, Michael (IS) wrote: > Does anybody know how to make the journal file go to a different location > than the database? Apprarently it's not treated as a "temporary" file. > Perhaps it should be??
It's essential not to treat the journal file as a temporary file (e.g put it in /tmp for a Unix environment). Temporary directories are wiped out at boot time, whereas a SQLite journal file is used after a crash and reboot to recover your database to a sane and usable state. And I agree with other people in this thread: it is pointless for you to mess about trying to optimize the operation of SQLite at this stage because your bottleneck to performance is the speed of your network link. You might somehow achieve a 5% improvement in speed by endless messing with SQLite whereas getting a faster path to your remote storage might get you a 50% improvement. Take a look at your network toplogy, the priority settings on your switches, etc.. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users