dépôts / lhc / web / wiklou.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 188099d) | patch
API: Enhancing ucuserprefix performance
authorRoan Kattouw <catrope@users.mediawiki.org>
Thu, 10 Apr 2008 11:57:27 +0000 (11:57 +0000)
committerRoan Kattouw <catrope@users.mediawiki.org>
Thu, 10 Apr 2008 11:57:27 +0000 (11:57 +0000)
commit3081fa9a5746aa667a68ee47c6bdc07a357b59e6
tree17e934f0906cd6ca850988fb44ee6881adeaff71tree | snapshot
parent188099df74e28f3594b1ab64df9b7d0a13adee03commit | diff
API: Enhancing ucuserprefix performance
* ucuserprefix now only works for anonymous users. This allows us to add WHERE rev_user=0 (fewer rows to scan) and use the user_timestamp index (so the ORDER BY rev_user_text DESC can be killed)
* ucuserprefix must be an IP containing at least two full octets, e.g. '12.345.', to ensure the resulting LIKE is somewhat sane
includes/api/ApiQueryUserContributions.php diff | blob | history
Wiklou, le Wiki du Wiklou