ADOdb contains a number of performance monitoring tools, such as query logging, hardware performance, and caching statistics. In order to use performance monitoring, the driver must be one of those specified below.
To add performance monitoring to the ADOdb system make a call to the
$db = newAdoConnection('db2'); $db->connect('','user','password','database'); /* * Initialize the performance monitoring module */ $perf = NewPerfMonitor($db);
A simple user interface to the performance monitoring tools is provided through the UI() method.
|logSql()||Enables or disables the logging functionality|
|expensiveSql()||Returns an analysis of expensive SQL statements from acquired data|
|suspiciousSql()||Returns an analysis of suspicious SQL statements from acquired data|
|invalidSql()||Returns an analysis of invalid SQL statements from acquired data|
|clearSql()||Empties the SQL logging table|