On Oct 31, 2019, at 3:51 AM, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> 
> delete from dataset;

Is that command representative of actual use, or are you deleting all rows just 
for the purpose of benchmarking?

I ask because if you’re going to just delete all rows in a table, it’s usually 
faster to DROP TABLE and then CREATE TABLE.

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to