mixed suspicioudSql()
The function suspiciousSql()
returns a list of SQL statements with high average execution times collected by the performance monitor logSql feature.
/* * Connection to DB2 database */ $perf = newPerfMonitor($db); /* * Enable logging */ $db->logSql(); /* * Execute invalid SQL statement */ $SQL = "SELECT * FROM act where actno > 200"; $db->execute($SQL); $h = $perf->suspiciousSql() print $h;
Avg Time | Count | SQL | Max | Min |
0.065087 | 1 | SELECT * FROM act where actno > 200 | 0.065087 | 0.065087 |
0.062797 | 1 | insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( CURRENT TIMESTAMP,?,?,?,?,?) | 0.062797 | 0.062797 |