Karl Tomlinson <[EMAIL PROTECTED]>
wrote:
> I've done a little looking into journals, fsyncs, and filesystems
> recently.
>
> One thing I'm trying to understand is whether there was a reason for
> SQLite choosing to use a rollback journal (of the steps to undo a
> transaction) rather than a replay journal (of the steps to perform a
> transaction).
It seems to me that with a replay journal, it would be rather difficult
to make this work:
begin;
insert into mytable values ('xyz');
select * from mytable;
end;
I would expect the select to include the row I've just inserted. But
with your scheme, the record is not in the database, but is still
sitting in the replay journal.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
