Blazegraph's query optimizer orders operations in a way that leads to a timeout in some cases where disabling the optimizer returns a result within seconds.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Smalyshev | T100235 Query optimizer pessimises queries | |||
| Open | None | T126122 Blazegraph Query optimizer pessimises query Deprecated_statements |
Event Timeline
Comment Actions
The query is:
SELECT ?wdLabel ?wdPLabel ?valueLabel ?wd ?wdP ?wds ?value
WHERE
{
# hint:Query hint:optimizer "None" .
?wds wikibase:rank wikibase:DeprecatedRank .
?wd ?p ?wds .
?wds ?v ?value .
?wdP wikibase:statementProperty ?v .
?wdP wikibase:claim ?p .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 100Works with optimizer disabled, times out with optimizer enabled.