Mdale has submitted this change and it was merged.

Change subject: cache db queries for Special:TimedMediaHandler for one hour
......................................................................


cache db queries for Special:TimedMediaHandler for one hour

Change-Id: Ic61bc69d5f66e47bc2701c3e29f9f67ed5753c03
---
M SpecialTimedMediaHandler.php
1 file changed, 7 insertions(+), 1 deletion(-)

Approvals:
  Mdale: Verified; Looks good to me, approved



diff --git a/SpecialTimedMediaHandler.php b/SpecialTimedMediaHandler.php
index 9910cc1..e23fc54 100644
--- a/SpecialTimedMediaHandler.php
+++ b/SpecialTimedMediaHandler.php
@@ -25,12 +25,18 @@
        }
 
        public function execute( $par ) {
+               global $wgMemc;
                $this->setHeaders();
                $out = $this->getOutput();
 
                $out->addModuleStyles( 'mediawiki.special' );
 
-               $stats = $this->getStats();
+               $key = wfMemcKey( 'TimedMediaHandler', 'stats' );
+               $stats = $wgMemc->get( $key );
+               if ( !$stats ) {
+                       $stats = $this->getStats();
+                       $wgMemc->add( $key, $stats, 3600 );
+               }
                $out->addHTML(
                        "<h2>"
                        . $this->msg( 'timedmedia-videos',  
$stats['videos']['total'] )->escaped()

-- 
To view, visit https://gerrit.wikimedia.org/r/54646
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Ic61bc69d5f66e47bc2701c3e29f9f67ed5753c03
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/TimedMediaHandler
Gerrit-Branch: master
Gerrit-Owner: J <jger...@wikimedia.org>
Gerrit-Reviewer: Mdale <md...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to