On 4/19/18, Quan Yong Zhai <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
