>Jay Sprenkle wrote: >The transaction doesn't seem any different than a snapshot of the >database that you can restore to. I just wondered why there were two >methods of doing the same thing.
Only in a single user/single thread case are they the same thing. With Sqlite that might always be the case, but with non-embedded databases it gets much more complicated.