Differences

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

--- v5:performance:suspicioussql [2021/08/22 22:07] – typo peterdd
+++ v5:performance:suspicioussql [2024/03/19 22:45] – format html example output as dokuwiki syntax peterdd
@@ Line 34: / Line 34: @@
 </code>
+<code>
 <html>
 <h3>Suspicious SQL</h3>
@@ Line 40: / Line 41: @@
 <tr><td>0.065087<td align=right>1<td><font size=-1><a target=sql205519396 href="?hidem=1&exps=1&sql=SELECT+%2A+FROM+act+where+actno+%3E+%27A%27&x#explain">SELECT * FROM act where actno &gt; 200</a></font><td>0.065087<td>0.065087</tr><tr><td>0.062797<td align=right>1<td><font size=-1><a target=sql1678387404 href="?hidem=1&exps=1&sql=insert+into+adodb_logsql+%28created%2Csql0%2Csql1%2Cparams%2Ctracer%2Ctimer%29+values%28+CURRENT+TIMESTAMP%2C%3F%2C%3F%2C%3F%2C%3F%2C%3F%29&x#explain">insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( CURRENT TIMESTAMP,?,?,?,?,?)</a></font><td>0.062797<td>0.062797</tr></table>
 </html>
+</code>
+====Suspicious SQL====
+The following SQL have high average execution times
+^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|