Difference between revisions of "Template:Slow"

From FollowTheScore
Jump to: navigation, search
(see bug report)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
:'''***Warning***''' This keyword can produce very slow and inefficient queries on your MediaWiki system, hurting performance for all users on the system.
+
:<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 [[Issue:Modifiedby and createdby produce inefficient SQL|bug report]].)
 +
<noinclude>
 +
== Background ==
 +
This template was written by [[User:Maiden_taiwan]] after the DPL <code>createdby</code> 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:
 +
 
 +
<pre>
 +
<dpl>
 +
namespace=
 +
createdby=someuser
 +
</dpl>
 +
</pre>
 +
 
 +
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.
 +
</noinclude>

Latest revision as of 16:23, 5 February 2013

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.