RE: svn commit: r1340603 - in /subversion/trunk/subversion/libsvn_wc: wc-queries.sql wc_db.c wc_db.h
From: Bert Huijben <bert_at_qqmail.nl>
Date: Sun, 20 May 2012 03:36:07 +0200
> -----Original Message-----
The problem was not in not really in using the index, but in the ?2 = '' part of the query to properly handle the working copy root.
As Sqlite only uses a single query plan, it notes that it needs a table scan to handle the ?2 = '' extrme case, and forgets the other optimizations.
We should split the performance critical queries in a normal and working copy root specific one (if one is necessary)
This is an archived mail posted to the Subversion Dev mailing list.