Differences

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

--- v5:performance:expensivesql [2021/08/22 22:09] – typo 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>
-<html>
+==== Output ====
-<h3>Expensive SQL</h3>
-<font size=1>Tuning the following SQL could reduce the server load substantially</font><br>
+{{:v5:performance:performance-expensive-sql.png}}
-<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>