On 4/19/18, Quan Yong Zhai <q...@msn.com> wrote: > I modified the wordcount.c in SQLite/test directory, to use the new upsert > > Before: > wordcount --all :memory: sqlite3.c > 2.406 wordcount --insert > 2.296 wordcount --insert --without-rowid > > After: > wordcount --all :memory: sqlite3.c > 1.701 wordcount --insert > 3.547 wordcount --insert --without-rowid > > As you can see, it’s very strangely ,in the table with rowid, the upsert > improved a lot, but in the table without rowidd, it’s slower than the origin > sql.
That's a good testing idea. Thank you. I will make a similar change and investigate the cause of the slowdown, and hopefully fix the problem. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
