v5:performance:suspicioussql
suspiciousSql
Syntax
string suspiciousSql()
Description
The function suspiciousSql()
returns a list of SQL statements with high average execution times collected by the performance monitor logSql feature, formatted as an HTML table.
Usage
/* * Connection to DB2 database */ $perf = newPerfMonitor($db); /* * Enable logging */ $db->logSql(); /* * Execute suspicious SQL statement */ $SQL = "SELECT * FROM act where actno > 200"; $db->execute($SQL); $h = $perf->suspiciousSql(); print $h;
Output
v5/performance/suspicioussql.txt · Last modified: 2024/03/21 16:14 by dregad