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

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
v5:performance:expensivesql [2016/01/13 02:14] – ↷ Page moved from performance:expensivesql to v5:performance:expensivesql 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