Rosemary Alles <al...@ipac.caltech.edu> wrote: > Is there no difference in behavior between a SINGLE select and several > of them within the context of transaction?
There is, of course, a difference between running one SELECT statement and running more than one, regardless of transactions. I guess you wanted to ask whether there's a difference between running the same set of statements within vs outside a transaction. There is only a difference if you have another connection (in the same or different process) that tries to modify the same database at the same time. It will be unable to do so while your transaction is in progress. So, if you issue several SELECTs within a transaction, their results are guaranteed to be consistent (e.g. if you run the same SELECT twice, it will produce the same results both times). If you run these SELECTs outside a transaction, the other connection could modify the data in between, which could lead to inconsistent results. This may or may not matter in your particular case. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
