Difference between revisions of "Template:Slow"

From FollowTheScore
Jump to: navigation, search
(Created page with "'''Warning:''' this keyword can produce very slow and inefficient queries on your MediaWiki system, hurting performance for all users on the system.")
 
(see bug report)
 
(4 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 17: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.