diff options
author | Frédéric Buclin <LpSolit@gmail.com> | 2013-01-16 19:05:22 +0100 |
---|---|---|
committer | Frédéric Buclin <LpSolit@gmail.com> | 2013-01-16 19:05:22 +0100 |
commit | d8643908a7d6243c361e670573af763067db408d (patch) | |
tree | b8e5b5df199351e6455843fc27a4c4e1e30433d9 /template | |
parent | 7b6b9a789a2bfc5707ba1eb85ad7ba5245af64a3 (diff) | |
download | bugzilla-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.tmpl | 11 | ||||
-rw-r--r-- | template/en/default/reports/report.html.tmpl | 4 |
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"> |