When trying to create a page that has been previously deleted, a message is shown to the user to remind that it was deleted before. That information is retrieved from the logging table, by matching the title.
Currently, there is no index for the log_title field in that table, hence the query is slow. We would like a new index on log_namespace, log_title to allow for such queries to be efficient.
- Use case: When opening the edit page for a title to create the page, a log extract may be shown of delete log actions.
- Source code:
- LogEventsList::showLogExtract( …, [ 'delete', 'move' ], [ 'lim' => 10, 'conds' => 'log_action != "revision"' ])