From: Andrew Dunstan <andrew@dunslane.net>
Date: Wed, 11 Feb 2009 01:28:10 +0000 (+0000)
Subject: use materialised dashboard table
X-Git-Url: https://git.exim.org/buildfarm-server.git/commitdiff_plain/efbe7205dc6f2e2ecc35ebf0fab7516674eef8c6

use materialised dashboard table
---

diff --git a/cgi-bin/show_status.pl b/cgi-bin/show_status.pl
index 975d52a..1c36337 100755
--- a/cgi-bin/show_status.pl
+++ b/cgi-bin/show_status.pl
@@ -39,8 +39,8 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass) or die("$dsn,$dbuser,$dbpass,$!");
 my $statement =<<EOS;
 
 
-  select *
-  from dashboard
+  select timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago, b.*
+  from dashboard_mat b
   order by branch = 'HEAD' desc,
         branch desc, $sort_clause 
         snapshot desc