On 8/2/18 7:02 AM, David Raymond wrote:
So for your test script there, try inserting a record with the violation ID a little bit later and see if it suddenly speeds up again. In my Python version of your script it does indeed speed back up again once the outstanding violation is fixed.
The main problem is that this bug makes it difficult to handle bugs in our code. A bug causing the FK violation automatically wastes a lot of time before being detected, because the slowdown is in the range of 1000X. FK violations aren't out of the ordinary or abnormal, they are a valid outcome of some queries, and should be handled reasonably.
Yuri _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users