The special page Special:UpdateEditCounts is used to populate and update the edit count displayed on the social profile of users.
This has at least a couple of problems:
- Lack of automation. An authorized user needs to push a button whenever the counts need to be updated. Until then, the edit count is frozen.
- It's not scalable. It does a count(*) on the entire revision table, grouping by actor. This is problematic on large wikis, specially when executed from the web interface, because there are time constraints, and slow queries like this risk getting killed by the PHP max_execution_time.
Creating a maintenance script will solve both problems (not directly the second, but would mitigate the timeout problem).