On Fri, Jan 16, 2015 at 3:47 AM, Hick Gunter <h...@scigames.at> wrote:
> It depends in how you define "update the index". > > If you mean "write to disk" then this happens "once, at the end of the > transaction" (the exact process differs depending on the journal mode). > > If you mean "change the index structure in memory" then (as already > noted) the changes will happen for each record touched. > > For large batch updates, it may be faster to drop the index before > performing the changes and recreate it afterwards. > Unless you change "a lot" of pages, in which case SQLite will start spilling pages from memory to disk before the end of the transaction, then write the final form of everything at the end of the transaction. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users