Last modified: 2014-05-16 14:51:45 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T67333, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 65333 - Wikibase\EntityPerPageTable::getItemsWithoutSitelinks slow query with large LIMIT offset
Wikibase\EntityPerPageTable::getItemsWithoutSitelinks slow query with large L...
Status: NEW
Product: MediaWiki extensions
Classification: Unclassified
WikidataRepo (Other open bugs)
master
All All
: Normal normal (vote)
: ---
Assigned To: Wikidata bugs
u=dev c=backend p=0
: need-volunteer
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-05-15 06:30 UTC by Sean Pringle
Modified: 2014-05-16 14:51 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sean Pringle 2014-05-15 06:30:45 UTC
This query form appears in the slow log for wikidatawiki on WMF S5:

SELECT /* Wikibase\EntityPerPageTable::getItemsWithoutSitelinks ? */ epp_entity_id AS entity_id FROM `wb_entity_per_page` LEFT JOIN `wb_items_per_site` ON ((ips_item_id = epp_entity_id)) WHERE (ips_site_page IS NULL) AND epp_entity_type = 'item' ORDER BY epp_page_id DESC LIMIT 1940000, 51;

Offset 1940000... wow! :-)

Can we cap the possible limit offset, or handle pagination differently?

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links