On Mon, Dec 30, 2013 at 8:56 AM, Raheel Gupta <raheel...@gmail.com> wrote:
> 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.
>
Why don't you provide us with a test case of some kind, or at least your
specific schema and the SQL you are running?
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
