Filtering URIs by path with tracker:uri-is-descendant() is slower than fn:starts-with()
According to @carlosg, it's better to filter filenames like this:
?file nie:url ?url .
FILTER (STRSTARTS (?url, "file:///home/sam"))
Than like this:
?file nie:url ?url .
FILTER (tracker:uri-is-descendant ("file:///home/sam", ?url))
The former allows SQLite to use the table index on the nie:url
property, while the latter does not.
We should re-implement tracker:uri-is-descendent so that there's no performance penalty to using it. Or we should deprecate it.