Currently, the performance of Special:TimedMediaHandler is apparently bad enough that we need to severely restrict who has access to it. We need to instead cache it well enough so that it can be available to anonymous users.
Version: unspecified
Severity: normal
Line 155 onwards in SpecialTimedMediaHandler:
'img_media_type = "VIDEO" AND (' . $condition . ')',
img_media_type isn't currently indexed in core (maybe it should be?)
Also, $condition may also not be, depending on it's contents
array( 'transcode_key' => $key ),
transcode_key from the transcode table isn't indexed (well, it is, as a second column, but if we're not using that one, it doesn't help)
That one can/should be trivially fixed by adding an extra index on it.
Table should be small enough to add the index straight off
(In reply to comment #2)
array( 'transcode_key' => $key ),
transcode_key from the transcode table isn't indexed (well, it is, as a second
column, but if we're not using that one, it doesn't help)That one can/should be trivially fixed by adding an extra index on it.
Table should be small enough to add the index straight off
jgerber wrote:
https://gerrit.wikimedia.org/r/#/c/35140/ should fix this bug, reviews welcome.