summaryrefslogtreecommitdiffstats
path: root/template
diff options
context:
space:
mode:
authorFrédéric Buclin <LpSolit@gmail.com>2013-01-16 19:05:22 +0100
committerFrédéric Buclin <LpSolit@gmail.com>2013-01-16 19:05:22 +0100
commitd8643908a7d6243c361e670573af763067db408d (patch)
treeb8e5b5df199351e6455843fc27a4c4e1e30433d9 /template
parent7b6b9a789a2bfc5707ba1eb85ad7ba5245af64a3 (diff)
downloadbugzilla-d8643908a7d6243c361e670573af763067db408d.tar.gz
bugzilla-d8643908a7d6243c361e670573af763067db408d.tar.xz
Bug 819432: Execute queries in two steps to improve performance
r=dkl a=LpSolit
Diffstat (limited to 'template')
-rw-r--r--template/en/default/list/list.html.tmpl11
-rw-r--r--template/en/default/reports/report.html.tmpl4
2 files changed, 10 insertions, 5 deletions
diff --git a/template/en/default/list/list.html.tmpl b/template/en/default/list/list.html.tmpl
index 3be607a38..dcc140cf2 100644
--- a/template/en/default/list/list.html.tmpl
+++ b/template/en/default/list/list.html.tmpl
@@ -72,10 +72,13 @@
[% IF debug %]
<div class="bz_query_debug">
- <p>[% query FILTER html %]</p>
- <p>Execution time: [% query_time FILTER html %] seconds</p>
- [% IF query_explain.defined %]
- <pre>[% query_explain FILTER html %]</pre>
+ <p>Total execution time: [% query_time FILTER html %] seconds</p>
+ [% FOREACH query = queries %]
+ <p>[% query.sql FILTER html %]</p>
+ <p>Execution time: [% query.time FILTER html %] seconds</p>
+ [% IF query.explain %]
+ <pre>[% query.explain FILTER html %]</pre>
+ [% END %]
[% END %]
</div>
[% END %]
diff --git a/template/en/default/reports/report.html.tmpl b/template/en/default/reports/report.html.tmpl
index 8dc4bc5a7..2ca5dd90f 100644
--- a/template/en/default/reports/report.html.tmpl
+++ b/template/en/default/reports/report.html.tmpl
@@ -61,7 +61,9 @@
%]
[% IF debug %]
- <p>[% query FILTER html %]</p>
+ [% FOREACH query = queries %]
+ <p>[% query.sql FILTER html %]</p>
+ [% END %]
[% END %]
<div align="center">