----- Original Message ----- From: Lothar M=E4rkle <[EMAIL PROTECTED]> Date: Sunday, March 13, 2005 11:39 pm Subject: Re: [sqlite] atomic db replacement
> > does anyone have a strategy for doing massive updates to a db and > atomicly> replacing it in a multi-process situation? > > Assuming you have a cgi-like application with many processes that just > looks up a row, displays and then exits. You can simple use the > rename call > to atomically replace the db file(see man 2 rename for bordercases) > withanother and without locking. > > lothar but this will lose any update currently begin written by any of the active cgi processes - even if they are in the middle of a transaction? -a