On 3/20/2013 9:21 AM, Michael Black wrote:
I can tell you the explain plan is notably different between those two inserts. This is with 3.7.14.1 If only I knew more about the details of what the plan means....one thing I noted is that keyinfo is opened twice for write on Test#2
That's because there are two (redundant) indexes on the same column that need to be updated - one explicitly created, and another implicit in UNIQUE constraint.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users