Perfect, That’s a big step of SQLite. I think one of our projects will benefit of the new upsert.
Thanks a lot. wordcount --all :memory: sqlite3.c 2.422 wordcount --insert 2.341 wordcount --insert --without-rowid 3.610 wordcount --replace 1.766 wordcount --replace --without-rowid 1.594 wordcount --upsert 1.625 wordcount --upsert --without-rowid 2.171 wordcount --select 2.281 wordcount --select --without-rowid 2.423 wordcount --update 2.391 wordcount --update --without-rowid 0.375 wordcount --delete 0.328 wordcount --delete --without-rowid 0.372 wordcount --query 0.328 wordcount --query --without-rowid 24.027 wordcount --all Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 ________________________________ From: sqlite-users <[email protected]> on behalf of Richard Hipp <[email protected]> Sent: Saturday, April 21, 2018 3:49:08 AM To: SQLite mailing list Subject: Re: [sqlite] UPSERT available in pre-release Please try again with the latest pre-release snapshot. On 4/19/18, Quan Yong Zhai <[email protected]> wrote: > Dear Richard, > > I modified the wordcount.c in SQLite/test directory, to use the new upsert > command: > > INSERT INTO wordcount(word,cnt) VALUES(?1,1) ON CONFLICT(word) DO UPDATE > SET cnt=cnt+1 > > 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. > > > > > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows > 10 > > > > ________________________________ > From: sqlite-users <[email protected]> on behalf > of Richard Hipp <[email protected]> > Sent: Thursday, April 19, 2018 6:29:55 PM > To: General Discussion of SQLite Database > Subject: [sqlite] UPSERT available in pre-release > > The latest pre-release snapshot [1] contains support for UPSERT > following the PostgreSQL syntax. The documentation is still pending. > Nevertheless, early feedback is welcomed. You can respond either to > this mailing list, or directly to me. > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
