ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:expensivesql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:performance:expensivesql [2021/08/22 22:09] – typo peterddv5:performance:expensivesql [2024/03/21 16:12] (current) – Screenshot with sample output dregad
Line 1: Line 1:
-====== expensiveSql ====== 
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP right box> <WRAP right box>
 +
 == Syntax == == Syntax ==
-  mixed expensiveSql()+  string expensiveSql()
 </WRAP> </WRAP>
 +
 ===== Description ===== ===== 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 ===== ===== Usage =====
 <code php> <code php>
Line 31: Line 34:
  
 print $h; print $h;
- 
 </code> </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>+
  
v5/performance/expensivesql.1629662940.txt.gz · Last modified: 2021/08/22 22:09 by peterdd