On a recent thread, some of you told me that if I wrap lots of "INSERT" statements inside "BEGIN TRANSACTION" and "END TRANSACTION", then executing "END TRANSACTION" will take the most (99%) of the time.
This is not happening. _bind() on a prepared statement and execution of "INSERT" are taking 70% of the time, but the "END TRANSACTION" only 30% of the time. The time between _bind() and execution of "INSERT" is roughly 50/50, so it's a total of: _bind(): 35% INSERT: 35% END TRANSACTION: 30% I would have expected the execution of INSERT to taken almost 0% within a transaction. Why is this not the case? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
