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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to