Every tool I use seems to be slow. It seems we have some broken indexes on the
databases.
Here is an execution report from my super count tool when it looked me up.
Time is logged in seconds.
[executiontime] => Array
(
[basic_stats] => Array
(
[queries] => Array
(
[0] => Array
(
[time] => 0.77
[query] => SELECT COUNT(*) AS count FROM
archive_userindex WHERE (`ar_user` ='14836860');
[result] => succeeded
)
[1] => Array
(
[time] => 18.95
[query] => SELECT rev_timestamp,
page_title, page_namespace FROM revision_userindex JOIN page ON page_id =
rev_page WHERE (`rev_user` = '14836860') AND `rev_timestamp` > 1 ORDER BY
rev_timestamp ASC LIMIT 0,2688354;
[result] => succeeded
)
)
[total] => 19.89
)
[replag] => Array
(
[total] => 0
[queries] => Array
(
[0] => Array
(
[time] => 0
[query] => SELECT UNIX_TIMESTAMP() -
UNIX_TIMESTAMP(rc_timestamp) as replag FROM recentchanges_userindex ORDER BY
rc_timestamp DESC LIMIT 1;
[result] => succeeded
)
)
)
[usergroups] => Array
(
[total] => 0.06
[queries] => Array
(
[0] => Array
(
[query] =>
http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Cyberpower678&usprop=groups&format=php
[time] => 0.06
[result] => succeeded
)
)
)
[namespaces] => Array
(
[total] => 0.1
[queries] => Array
(
[0] => Array
(
[query] =>
http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php
[time] => 0.1
[result] => succeeded
)
)
)
)
Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l
