[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-12-31 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

Jan Gerber jger...@wikimedia.org changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-12-07 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

Andre Klapper aklap...@wikimedia.org changed:

   What|Removed |Added

   Keywords||patch-in-gerrit

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-12-05 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

--- Comment #6 from Jan Gerber jger...@wikimedia.org ---
https://gerrit.wikimedia.org/r/#/c/35140/ should fix this bug, reviews welcome.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-18 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

duplicate...@googlemail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||duplicate...@googlemail.com
 Resolution||FIXED

--- Comment #4 from duplicate...@googlemail.com 2012-11-18 13:33:31 UTC ---
(In reply to comment #3)
 https://gerrit.wikimedia.org/r/32236

Status Merged

-- 
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

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-18 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

Sam Reed (reedy) s...@reedyboy.net changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |

--- Comment #5 from Sam Reed (reedy) s...@reedyboy.net 2012-11-18 15:02:07 
UTC ---
I'm not sure this is actually fixed yet. I just addressed one issue

-- 
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

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-07 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

Rob Lanphier ro...@wikimedia.org changed:

   What|Removed |Added

   Priority|Unprioritized   |Normal

-- 
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

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-07 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

Sam Reed (reedy) s...@reedyboy.net changed:

   What|Removed |Added

   Keywords||performance
 CC||s...@reedyboy.net

--- Comment #1 from Sam Reed (reedy) s...@reedyboy.net 2012-11-07 17:23:02 
UTC ---
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

-- 
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

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-07 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

--- Comment #2 from Sam Reed (reedy) s...@reedyboy.net 2012-11-07 17:25:02 
UTC ---
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

-- 
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

[Bug 41854] Cache expensive elements in Special:TimedMediaHandler

2012-11-07 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=41854

--- Comment #3 from Sam Reed (reedy) s...@reedyboy.net 2012-11-07 17:34:15 
UTC ---
(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

-- 
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