Differences

This shows you the differences between two versions of the page.

--- v5:performance:expensivesql [2024/03/19 22:50] – format html example output as dokuwiki syntax peterdd
+++ v5:performance:expensivesql [2024/03/21 16:12] (current) – Screenshot with sample output dregad
@@ Line 1: / Line 1: @@
-====== expensiveSql ======
 ~~NOTOC~~
 <WRAP right box>
 == Syntax ==
-  mixed expensiveSql()
+  string expensiveSql()
 </WRAP>
 ===== Description =====
-The function ''expensiveSql()'' returns a list of SQL statements with very high execution times collected by the performance monitor logSql feature.
+The function ''expensiveSql()'' returns a list of SQL statements with very high execution times collected by the performance monitor logSql feature, formatted as an HTML table.
 ===== Usage =====
 <code php>
@@ Line 31: / Line 34: @@
 print $h;
 </code>
-<code>
+==== Output ====
-<html>
-<h3>Expensive SQL</h3>
-<font size=1>Tuning the following SQL could reduce the server load substantially</font><br>
-<table border=1 bgcolor=white><tr><td><b>Load</b><td><b>Count</b><td><b>SQL</b><td><b>Max</b><td><b>Min</b></tr>
-</table>
-</html>
-</code>
-====Expensive SQL====
-Tuning the following SQL could reduce the server load substantially:
+{{:v5:performance:performance-expensive-sql.png}}
-^Load^Count^SQL^Max^Min^
-(missing demo data here?)