Hi all,
I've read some of the standard help on sqlite.org but have not studied the code at all, so turning to the experts for some advice
(there is no urgency, I would just really like some insight).
Could someone please shortly discuss performance considerations for having nested Transactions vs. sequential transactions in
SQLite. I realise that nested ones are safer, but Im always looking to find performance increases. Now, to my mind, in the following
two examples the safety is no issue:
A)
Begin
Begin
...
Commit;
Begin
...
Commit;
Begin
...
Commit;
Commit;
B)
Begin
Begin
Begin
Begin
...
Commit;
....
Commit;
....
Commit;
....
Commit;
- I think that B will be faster, or at least, that's what I seem to glean from
the help texts - but I'm not very sure.
Is B faster or A faster? and if so, are there circumastances in which this
might differ?
Any other considerations needed to keep in mind?
Thank you very much and have a great day!
RS
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
