Wed, Feb 07, 2007 at 07:36:10PM +0200: DragonK wrote: > On 2/7/07, Teg <[EMAIL PROTECTED]> wrote: > > > >Hello ohadp, > > > >Well, my experience is, particularly when it's users using it and not > >a personal project, that corruption happens fairly frequently when you > >use this pragma. That's why I don't use it any more in my production > >code. > > > >Transactions are far safer and fast too. > > > >Indeed, transactions are safer. > > But I wonder, why did you experienced corruption with this pragma? Was it > because of crashes of the OS or the application? Or are there other factors > which can corrupt the data if not syncing ? As I understood from the > documentation, the only thing that can corrupt data when using this pragma > are crashes and power failures.
Hello, If you don't care of corruption on crashes and power failures, you can modify sqlite to write your temporary '-journal' files in a ramfs mount directory. DB file: /opt/sqlite/mydb Journal in smtg like: /ramfs/opt#sqlite#mydb-journal -- Guillaume FOUGNIES Eulerian Technologies ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
