Template:Slow: Difference between revisions

From DynamicPageList3 Manual
Content deleted Content added
mNo edit summary
No edit summary
Line 1:
:<span style="font-weight:bold;color:red;text-decoration:underline;">Warning:</span> This keyword can produce very slow and inefficient queries on your MediaWiki system, potentially impacting performance for all users. (See [[http://followthescore.org/dpldemo/index.php/Issue:Modifiedby and createdby produce inefficientModifiedby_and_createdby_produce_inefficient_SQL SQL|bug report]].)
<noinclude>
== Background ==

Revision as of 04:00, 31 July 2019

Warning: This keyword can produce very slow and inefficient queries on your MediaWiki system, potentially impacting performance for all users. (See bug report.)

Background

This template was written by User:Maiden_taiwan after the DPL createdby keyword hurt performance on his MediaWiki system significantly. On a MediaWiki site with 100,000 articles and 3,000 users, this DPL took 2.5 minutes to run:

<dpl>
namespace=
createdby=someuser
</dpl>

People were making these DPL calls all the time to find out what articles they had created. When two of these ran at once, it significantly hurt wiki performance.