Page MenuHomePhabricator

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

Description


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

Details

Reference
bz50187

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 2:04 AM
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 removed a subscriber: Unknown Object (MLST).
Lydia_Pintscher removed a subscriber: Unknown Object (MLST).
matej_suchanek set Security to None.