To substantially improve the performance of the queries that retrieve
backlink/template/image information, I would like to propose an index change to
these tables:
pagelinks: pl_namespace index: add pl_from
templatelinks: tl_namespace index: add tl_from
imagelinks: il_to index: add il_from
The additional field will allow multi-page queries to limit results and have an
easy way to continue the query without using filesort.
Additionally, I suspect that because the *_from fields are needed in the output,
having it as part of the index removes the need to actually read the table, but
rather MySQL will get all fields from the index itself. Since every “what points
to X / where is X embedded” query uses the *_from field, it would be of benefit
as well.
Version: 1.7.x
Severity: enhancement
OS: Windows XP
Platform: PC