Igor Tandetnik wrote: > > > > There is another reason that is more or less specific to SQLite: a batch > of data manipulation (insert, update and delete) statements completes > much faster when all statements are executed under a single transaction. > > > I understeand that if I use them, and some serious error occures then > > there is a rollback so that my application can know the place where is > > not updated , but do I need it for a simple insert or update of 1 > > record ? >
Igor, you seem to have answered a question I wanted to pose: a program I wrote that inserts some 100 rows consisting of no more than four columns takes several seconds, almost all time spent in the INSERT statement. I will try to do this with a transaction. Regards, Arjen