Simon, does a real disk have to be a rotating hard disk? Is there problem with SSDs as far as SQLite is concerned?
On Mon, Mar 3, 2014 at 2:21 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
