Last modified: 2013-01-11 19:28:56 UTC
For modules with js and css pages, the ResourceLoader is checking the touched date twice for all pages of that module. The first time, when building the CSS and the second time, when building the scripts. For example: SELECT page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) Callers: MediaWiki::run/MediaWiki::main/MediaWiki::finalCleanup/OutputPage::output/SkinTemplate::outputPage/Skin::bottomScripts/OutputPage::getBottomScripts/OutputPage::getScriptsForBottomQueue/OutputPage::makeResourceLoaderLink/ResourceLoaderWikiModule::isKnownEmpty/ResourceLoaderWikiModule::getTitleMtimes/DatabaseBase::select SELECT page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) Callers: MediaWiki::run/MediaWiki::main/MediaWiki::finalCleanup/OutputPage::output/SkinTemplate::outputPage/OutputPage::headElement/OutputPage::buildCssLinks/OutputPage::makeResourceLoaderLink/ResourceLoaderWikiModule::isKnownEmpty/ResourceLoaderWikiModule::getTitleMtimes/DatabaseBase::select This is the same for the group-*.js/.css pages (ResourceLoaderUserGroupsModule). When the module only contains css pages, there is only one select (ResourceLoaderNoscriptModule) So you have 5 queries for loggedin users. You can reduce this to 3, maybe combine all to one query? When this is already done in the ResourceLoader2, than mark this as FIXED. Thanks.