Thanks....I understand! But is it possible to set that dir? It isn't a big problem for me if I lost some records in case of failure. My rfs is in flash-memory and every transacation take a very long time. I must reduce this time! Thanks.
Max
Danny Reinhold wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
