Maniphest T185576

Improve performance of the search service
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Hjfocs
	Jan 23 2018, 2:52 PM

Tags

Referenced Files

None

Subscribers

Description

See T180486
Also hitting T164773

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Hjfocs	T185571 Prepare 2.0 alpha release
		Resolved		Hjfocs	T185576 Improve performance of the search service

Event Timeline

Hjfocs created this task.Jan 23 2018, 2:52 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 23 2018, 2:52 PM

Hjfocs added a parent task: T185571: Prepare 2.0 alpha release.Jan 23 2018, 2:52 PM

Hjfocs moved this task from To do to Upcoming on the Wikidata-primary-sources board.Jan 24 2018, 9:20 AM

Hjfocs moved this task from Upcoming to Doing on the Wikidata-primary-sources board.Jan 24 2018, 3:24 PM

no parameters given = slow: GRAPH ?g { ?s ?p ?o };
with dataset = slow, e.g., 31sec, 366ms: GRAPH <$dataset> { ?s ?p ?o};
with property = fast, e.g., 455ms GRAPH ?g { ?s $property ?o };
with value = slow: GRAPH ?g { ?s ?p ?o { SELECT ?o WHERE { ?o ?x $value} };
with property and value = slow

sed -n '${OFFSET},${LIMIT}'p ${QUICKSTATEMENT_DATASET} would actually do the job when no property and/or value are given!

Solution: add a wd:Qxxx a wikibase:Item triple at upload/update time.