Your "labeled" example just ran for me in 121ms.
Maybe the server gets overloaded at times and goes into disk swap? Nothing to do with the query?
On Wed, Sep 9, 2015 at 2:06 PM James Heald j.heald@ucl.ac.uk wrote:
Prompted by this thread at Project Chat, https://www.wikidata.org/wiki/Wikidata:Project_chat#Identical_data_sets
here's a query to find multiple humans with nationality:Greece that have the same day of birth and day of death: http://tinyurl.com/ow6lpen It produces one pair, and executes in about 0.6 seconds.
Here's a query to try to add item numbers and labels to the previous search: http://tinyurl.com/ovjwzc9
It *just* completes, taking just over 60 seconds to execute.
(Please don't merge the two items yet, because that will destroy the example).
Analogous queries with lookups for France (71 apparent sets of duplicates), UK (32), and Italy(14) fail to complete.
Two questions therefore: (1) Why are the two queries taking such different times to run ? (2) Is there a good way to rewrite the second to make it faster ?
Obviously the second query as written at the moment involves a sub-query, which inevitably must make it a bit slower -- but given the solution set of the sub-query only has two rows, and an exact date for a given property ought to be a fairly quick key to look up, why is the second query taking 100 times longer than the first ?
And is there a better way I should be doing this, since the query does appear to be producing useful real matches ?
Thanks,
James.
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata