| matej_suchanek added a project: Performance. matej_suchanek edited the task description. (Show Details) |
EDIT DETAILS
This query form appears in the slow log for wikidatawiki on WMF S5:
```lang=mysql
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;
51;
```
Offset 1940000... wow! :-)
Can we cap the possible limit offset, or handle pagination differently?
--------------------------
**Version**: master
**Severity**: normal
**Whiteboard**: u=dev c=backend p=0or handle pagination differently?
```lang=mysql
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;
51;
```
Offset 1940000... wow! :-)
Can we cap the possible limit offset, or handle pagination differently?
--------------------------
**Version**: master
**Severity**: normal
**Whiteboard**: u=dev c=backend p=0or handle pagination differently?
TASK DETAIL
EMAIL PREFERENCES
To: matej_suchanek
Cc: Ricordisamoa, Aklapper, daniel, Wikidata-bugs, Springle, Lydia_Pintscher, Vali.matei, D3r1ck01, Izno, aude, GWicke, Mbch331, Jay8g
Cc: Ricordisamoa, Aklapper, daniel, Wikidata-bugs, Springle, Lydia_Pintscher, Vali.matei, D3r1ck01, Izno, aude, GWicke, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
