https://bugzilla.wikimedia.org/show_bug.cgi?id=4715
Roan Kattouw <roan.katt...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |roan.katt...@gmail.com
--- Comment #54 from Roan Kattouw <roan.katt...@gmail.com> 2011-04-26 15:13:57
UTC ---
(In reply to comment #53)
> > Why would we want to index the summaries?
>
> To allow covering index reads for features like 'user contributions'
To clarify: one thing that is not in the default MW schema but is on the WMF
databases is an extended usertext_timestamp index on the revision table that
covers all fields selected by the user contributions query. This allows faster
retrieval of the results: the database doesn't have to look at the actual row
because all of the data is already in the index.
Vanilla MW:
KEY `usertext_timestamp` (`rev_user_text`, `rev_timestamp`)
WMF:
KEY `usertext_timestamp` (`rev_user_text`, `rev_timestamp`, `rev_user`,
`rev_deleted`, `rev_minor_edit`, `rev_text_id`, `rev_comment`)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
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
