Sir, I tested the method of the following :
sqlite3_exec("INSERT OR IGNORE INTO ....;");
if( sqlite3_changes()==0 ){
sqlite3_exec("UPDATE ...");
}
I have seen my performance degrade from 10000 records / second to 10000
records / 10 seconds after 3 million UNIQUE Checksums inserted. Am I doing
anything wrong ? BTW, there were only 10 CONFLICTS in 3 Million rows. So
they are all unique 20 Byte Sha1 Checksums. I am committing at 10000
inserts.On Mon, Dec 30, 2013 at 6:38 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Dec 30, 2013 at 7:48 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > > The wordcount.c test program does the above using prepared statements and > > exceeds 348,000 inserts+updates per second on my desktop.... > > > > Further information: My desktop is a relatively new and fast SSD machine. > A 3-year-old ubuntu machine with spinning disks did over 250,000 > inserts+updates per second and a beagleboard black ( > http://beagleboard.org/products/beaglebone%20black) did just shy of 20,000 > inserts+updates per second on the same test case of 791319 insert+updates. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
