On 9 Jun 2018, at 4:38pm, Ben Asher <benashe...@gmail.com> wrote: > Oh interesting! Is that optimization documented anywhere (website, code, or > otherwise)?
I think I got my information when the change was announced or discussed on this list. However I now find that there's documentation on the web. See the bottom section of <https://sqlite.org/lang_delete.html> Although that text doesn't mention it, the optimization covers not only deleting the entire table's data in one short operation, but also deleting the data of each index in one short operation. As you can imagine, this is much faster than deleting rows one-by-one. Simon. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users