Re: [Wikidata] Use of Sparql service is going through the roof

Thanks, all! I ran each query separately and reassembled the results in a spreadsheet, so I think I got what I was after. Brand new to SPARQL, so I'll try and figure out your correct query above. Thanks again, d On Fri, Nov 6, 2015 at 5:40 PM, James Heald wrote: > Hi David, >

Re: [Wikidata] Use of Sparql service is going through the roof

Hi David, I think the issue with your query was with the line OPTIONAL {?nat rdfs:label ?nat_label filter (lang(?nat_label) = "en") .} The problem was that if the photographer didn't have a P27, so ?nat wasn't bound in the previous OPTIONAL line, then when it gets to the line above, with

Re: [Wikidata] Use of Sparql service is going through the roof

Might this be affecting our searches? The following query times out very quickly on Chrome, and runs forever in Firefox before crashing the whole browser (or is there a problem with my query?) PREFIX wd: PREFIX wdt: PREFIX

[Wikidata] Use of Sparql service is going through the roof

Does anyone know what's going on with the Sparql service ? Up until a couple of days ago, the most hits ever in one day was about 6000. But according to http://searchdata.wmflabs.org/wdqs/ two days ago suddenly there were 6.77 *million* requests, and yesterday over 21 million. Does

Re: [Wikidata] Use of Sparql service is going through the roof

Tangential question - is there a similar dashboard for WDQ (no S)? Or better yet, one that charts both query services so that they can be compared? Tom On Fri, Nov 6, 2015 at 9:27 AM, James Heald wrote: > Does anyone know what's going on with the Sparql service ? > > Up

Re: [Wikidata] Use of Sparql service is going through the roof

On 06/11/15 18:04, Mikhail Popov wrote: Hi! We looked at the logs. 21,740,641 requests are coming from a single IP without a user agent that we can't geolocate because it's in the 10 range. Looking into the actual queries revealed that it's probably a broken bot. Stas said "the query makes no

Re: [Wikidata] Use of Sparql service is going through the roof

Hi! We looked at the logs. 21,740,641 requests are coming from a single IP without a user agent that we can't geolocate because it's in the 10 range. Looking into the actual queries revealed that it's probably a broken bot. Stas said "the query makes no sense and is broken" and that it "looks

Re: [Wikidata] Use of Sparql service is going through the roof

Hi! > Does anyone know what's going on with the Sparql service ? > > Up until a couple of days ago, the most hits ever in one day was about > 6000. > > But according to > http://searchdata.wmflabs.org/wdqs/ > > two days ago suddenly there were 6.77 *million* requests, and yesterday > over

Re: [Wikidata] Use of Sparql service is going through the roof

Hi! > Might this be affecting our searches? The following query times out very > quickly on Chrome, and runs forever in Firefox before crashing the whole > browser (or is there a problem with my query?) The symptoms you describe seem to suggest you have too many results for this query and

Re: [Wikidata] Use of Sparql service is going through the roof

On 11/6/15 9:27 AM, James Heald wrote: > Does anyone know what's going on with the Sparql service ? > > Up until a couple of days ago, the most hits ever in one day was about > 6000. > > But according to > http://searchdata.wmflabs.org/wdqs/ > > two days ago suddenly there were 6.77 *million*

Re: [Wikidata] Use of Sparql service is going through the roof

On 11/6/15 1:04 PM, Mikhail Popov wrote: > Hi! We looked at the logs. 21,740,641 requests are coming from a > single IP without a user agent that we can't geolocate because it's in > the 10 range. > > Looking into the actual queries revealed that it's probably a broken > bot. Stas said "the query