Hi
I have a TDB instance (0.8.10) containing about 207m triples. I've run
tdbstats and moved stats.opt into the appropriate place.
I've noticed that running the same query multiple times in succession
results in successively shorter query times, up to a point. For
example, on an otherwise-idle TDB instance, the query
SELECT ?facet ?val (COUNT(?val) as ?vc) WHERE { ?id a ?val . ?id
?facet ?val . } GROUP BY ?facet ?val ORDER BY DESC(?vc) LIMIT 25
Takes 3707s, then 1424s, then 345s where it seems to stay for subsequent runs.
What's the reason for this initial improvement and subsequent tailing
off - are the indexes being optimised with every query?
Glenn.
