> 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) with another and without locking. lothar
