Queries with ?p wikibase:propertyType wikibase:ExternalId likely to time-out
Open, MediumPublic
Actions

Assigned To

None

Authored By

	Esc3300
	Dec 7 2016, 2:27 PM

Description

The query mentioned in T144476 times-out when using

	?p wikibase:propertyType wikibase:ExternalId .

but works when replacing this with

	?p wdt:P31 wd:Q22964274 .

The former (1500+) is slightly more frequent than the later (74), but still, it the number of properties is fairly limited. Using hint: didn't help either.

Related Objects

Mentioned In: T152773: COUNT with GROUP BY timing out if used as sub query
Mentioned Here: T152773: COUNT with GROUP BY timing out if used as sub query
T144476: [feature request] add count of external-ids to rdf (Wikidata)

Event Timeline

Esc3300 created this task.Dec 7 2016, 2:27 PM

Restricted Application added projects: Wikidata, Discovery-ARCHIVED. · View Herald TranscriptDec 7 2016, 2:27 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Esc3300 updated the task description. (Show Details)Dec 7 2016, 2:27 PM

Esc3300 mentioned this in T152773: COUNT with GROUP BY timing out if used as sub query.Dec 11 2016, 4:20 PM

Smalyshev moved this task from Incoming to Blazegraph on the Wikidata-Query-Service board.Dec 14 2016, 1:50 AM

For me, this query:

SELECT * WHERE { 
  ?a wikibase:propertyType wikibase:ExternalId 
}

finishes in 173 ms. Maybe there was a load on the server or something? Doesn't reproduce now. If it's a different query, please update.

The full query in the other bug is this. It still times out unless the replacement is made. Somehow things go wrong when Blazegraph tries to combine the parts.

Esc3300 reopened this task as Open.Dec 16 2016, 6:10 PM

Oh, ok, it seems to be the same subquery bug as in T152773

Is it? It still times-out when applying the solution suggested there: sample

Smalyshev triaged this task as Medium priority.Feb 12 2018, 8:06 AM

Lydia_Pintscher moved this task from incoming to monitoring on the Wikidata board.Mar 6 2018, 9:24 AM

Queries with ?p wikibase:propertyType wikibase:ExternalId likely to time-outOpen, MediumPublicActions

Description

Related Objects

Event Timeline

Queries with ?p wikibase:propertyType wikibase:ExternalId likely to time-out
Open, MediumPublic
Actions