https://bugzilla.wikimedia.org/show_bug.cgi?id=18229
Summary: Recentchanges for logged-in users uses way too many
queries
Product: MediaWiki
Version: 1.14-svn
Platform: All
OS/Version: All
Status: NEW
Severity: enhancement
Priority: Normal
Component: RecentChanges
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: roan.katt...@home.nl
Viewing Special:Recentchanges as a logged-in user results in a huge amount of
database queries. In particular, the following three queries are run for every
row:
SELECT /* Title::loadRestrictions */ * FROM `page_restrictions` WHERE
pr_page = '142'
SELECT /* Title::loadRestrictionsFromRow */ page_restrictions FROM `page`
WHERE page_id = '142' LIMIT 1
SELECT /* Title::getLatestRevID */ page_latest FROM `page` WHERE page_id =
'142' LIMIT 1
It should be easy to merge the first two queries. Also, the results aren't
cached, which means that 5 changes to page_id 142 results in the aforementioned
query block being run 5 times, each time with the exact same results.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
