https://bugzilla.wikimedia.org/show_bug.cgi?id=10788
Asher Feldman <afeld...@wikimedia.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |afeld...@wikimedia.org
--- Comment #15 from Asher Feldman <afeld...@wikimedia.org> 2012-06-20 00:05:41
UTC ---
I don't think we currently need the new revision index in order to support user
edits per page queries.
>From testing queries like:
select * from revision where rev_page = 1952670 and rev_user_text = "HBC AIV
helperbot7" order by rev_timestamp desc limit 50;
where that page id =
http://en.wikipedia.org/wiki/Wikipedia:Administrator_intervention_against_vandalism
with > 800k edits and that user has > 122k edits and it ran in ~30ms on a prod
enwiki db. I got similar times against frequent editors of the India article,
and when querying both with non-existent rev_user_text values.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
