thank you, that is exactly what I searched for. Best Martin
----- Ursprüngliche Mail ---- Von: Igor Tandetnik <[EMAIL PROTECTED]> An: SQLite <sqlite-users@sqlite.org> Gesendet: Montag, den 22. Mai 2006, 15:03:03 Uhr Betreff: [sqlite] Re: ACID for attached databases Martin Pfeifle <[EMAIL PROTECTED]> wrote: > We do not have memory databases. But I do not understand how > atomicity is achieved. > I understand that the ACID principle can be realized by means of the > fsync command. But how does this work for more than one database > file? Can anyone explain that to me, please. See http://sqlite.org/lockingv3.html, particularly section 4 dealing with journal files. Igor Tandetnik