[[Special:UnconnectedPages]] insufferably slow when offset exceeds ~30k
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	matmarex
	Jun 25 2013, 6:27 PM

Description

Version: unspecified
Severity: normal
See Also:
T51137: Implement UnconnectedPages in the api
{T68536}

Details

Reference: bz50187

Related Objects
Search...

Status	Assigned	Task
Duplicate	None	T52187 [[Special:UnconnectedPages]] insufferably slow when offset exceeds ~30k
Open	None	T67168 SpecialWikibaseQueryPage has no caching
Resolved	Ladsgroup	T164906 Investigate performance of SpecialWikibaseQueryPage components without caching

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 2:04 AM

• bzimport added projects: MediaWiki-extensions-WikibaseClient, patch-welcome, Performance Issue.

• bzimport set Reference to bz50187.

• bzimport added a subscriber: Unknown Object (MLST).

matmarex created this task.Jun 25 2013, 6:27 PM

(Meh, submitted before I finished filing the bug.)

Probably caused by using LIMIT+OFFSET in SQL queries instead of some index.

This query page is rather weird if you compare it to the build in pages. You would expect it to run on a daily basis and keep results cached. Now it seems to run every time someone opens it.

It's also basically a complement of [[Special:PagesWithProp/wikibase_item]] (recently added in core), so even uncached queries should be blazing fast.

Lydia_Pintscher added a project: Wikidata.Dec 1 2014, 2:38 PM

Lydia_Pintscher removed a subscriber: Unknown Object (MLST).

aude closed this task as a duplicate of T74696: Database query error on [[Special:UnconnectedPages]].May 12 2015, 11:39 PM

matej_suchanek mentioned this in T51137: Implement UnconnectedPages in the api.Jun 18 2015, 1:49 PM

matej_suchanek updated the task description. (Show Details)Jun 18 2015, 1:51 PM

matej_suchanek set Security to None.