On 3 Mar 2014, at 6:03pm, L. Wood <lwoo...@live.com> wrote: > _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?
Have you used any PRAGMAs which defeat ACID ? In other words, anything that speeds SQLite up ? Are you writing to a real file on a real rotating hard disk ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users