Hi > I have noticed that during my program execution a file named db-journal > is created in the same dir > of my db file. > How can I change the dir in wich the db-journal file is created ? > > I want that all db-journal file is created in a dir mounted on ramdisk > to improve performance of my application? > Is it a bad idea ? Yes, it is a bad idea. The journal file is used to recover data in case of failure. If you open a large transaction and insert thousends of rows and in the middle of the transaction your computer crashes. Then SQLite uses the journal file to restore your database and to undo the half completed transaction...
- Danny -- Danny Reinhold Reinhold Software & Services --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
