Last modified: 2013-04-22 16:14:17 UTC
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.
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 https://gerrit.wikimedia.org/r/32236
(In reply to comment #3) > https://gerrit.wikimedia.org/r/32236 Status Merged
I'm not sure this is actually fixed yet. I just addressed one issue
https://gerrit.wikimedia.org/r/#/c/35140/ should fix this bug, reviews welcome.