ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:performance:expensivesql

Differences

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

Link to this comparison view

Next revision		Previous revision
Last revisionBoth sides next revision
performance:expensivesql [2015/08/23 16:44] – created mnewnhamv5:performance:expensivesql [2024/03/19 22:50] – format html example output as dokuwiki syntax peterdd
Line 21: Line 21:
  
 /* /*
- * Execute invalid SQL statement+ * Execute expensive SQL statement
 */ */
 $SQL = "SELECT * FROM act where actno > 200"; $SQL = "SELECT * FROM act where actno > 200";
Line 28: Line 28:
  
  
-$h = $perf->expensiveSql()+$h = $perf->expensiveSql();
  
 print $h; print $h;
Line 34: Line 34:
 </code> </code>
  
 +<code>
 <html> <html>
 <h3>Expensive SQL</h3> <h3>Expensive SQL</h3>
Line 40: Line 41:
 </table> </table>
 </html> </html>
 +</code>
 +
 +
 +====Expensive SQL====
 +
 +Tuning the following SQL could reduce the server load substantially:
 +
 +^Load^Count^SQL^Max^Min^
  
 +(missing demo data here?)
v5/performance/expensivesql.txt · Last modified: 2024/03/21 16:12 by dregad