Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-11 Thread Stas Malyshev
Hi! > What's the URL of the dataset loaded into your Blazegraph DBMS? Ideally, > we should have this data available from a variety of SPARQL Query > Services [1]. The data is from https://dumps.wikimedia.org/wikidatawiki/entities/ plus streaming updates from Wikidata. You can see RDF format descr

Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-11 Thread Stas Malyshev
Hi! >> 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 >> sec

Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-09 Thread Kingsley Idehen
On 9/9/15 4:07 PM, Stas Malyshev wrote: > Hi! > >> > 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

Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-09 Thread Stas Malyshev
Hi! > 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: >

Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-09 Thread James Heald
Are you sure? 121 ms ?? It's consistently not working for me. (Whereas the first query consistently does; but even that just took 457 ms). However, I have been finding Reasonator's date lookup feature, eg https://tools.wmflabs.org/reasonator/?date=1889-11-10 a very very useful way to work

Re: [Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-09 Thread Magnus Manske
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 wrote: > Prompted by this thread at Project Chat, >https://www.wikidata.org/wiki/Wikidata:Project_chat

[Wikidata] Why do these two SPARQL queries take such different times to run?

2015-09-09 Thread James Heald
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