Difference between revisions of "Template:Slow"
From FollowTheScore
(see bug report) |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | 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 [[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.