Database Abstraction Layer for PHP https://www.adodb.org/dokuwiki/ 2026-05-17T02:04:48+00:00 https://www.adodb.org/dokuwiki/ https://www.adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2016-01-13T01:14:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:clearsql&rev=1452647653&do=diff clearSql Syntax void clearSql() Description The method clearSql() empties entries from the SQL logging table earlier than the current timestamp. This allows the log to be cleared while the logging system is still in use. Known Issues Because the method uses a 'delete from' methodology, and that the logging system may accumulated substantial volumes of data text/html 2016-01-13T01:14:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:cpuload&rev=1452647653&do=diff cpuLoad Syntax mixed cpuLoad () Description The function cpuLoad() returns an array of CPU loads under windows, a single integer value under unix, or false if the information is not available. Windows After PHP version 5.4, the Windows PHP extension for COM objects is not enabled by default. To enable it, add text/html 2024-03-21T15:12:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:expensivesql&rev=1711033949&do=diff Syntax string expensiveSql() Description The function expensiveSql() returns a list of SQL statements with very high execution times collected by the performance monitor logSql feature, formatted as an HTML table. Usage /* * Connection to DB2 database */ $perf = newPerfMonitor($db); /* * Enable logging */ $db->logSql(); /* * Execute expensive SQL statement */ $SQL = "SELECT * FROM act where actno > 200"; $db->execute($SQL); $h = $perf->expensiveSql(); print $h; text/html 2017-05-17T16:48:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:healthcheck&rev=1495039715&do=diff healthCheck Syntax mixed healthCheck() Description The method healthCheck() executes a single database health check pass and writes the information to an html format table. The output provided is the same as that returned by healthCheckcli(). There is no consistency between databases as to the information returned, as it is dependent on what information is publicly exposed by the database. text/html 2021-08-22T20:11:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:healthcheckcli&rev=1629663073&do=diff healthCheckCli Syntax mixed healthCheckCli() Description The method healthCheckCli() executes a single database health check pass and reports to the console. The output provided is the same as that stored by the healthCheck(). There is no consistency between databases as to the information returned, as it is dependent on what information is publicly exposed by the database. text/html 2016-01-13T03:05:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:index&rev=1452654357&do=diff Performance Monitoring Pages in this namespace: * clearSql * cpuLoad * healthCheck * healthCheckCli * invalidSql * logSql * Performance Monitoring * suspiciousSql * Syntax * uI text/html 2024-03-21T15:16:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:invalidsql&rev=1711034163&do=diff invalidSql Syntax string invalidSql() Description The function invalidSql() returns a list of invalid SQL statements collected by the performance monitor logSql feature, formatted as an HTML table. Usage /* * Connection to DB2 database */ $perf = newPerfMonitor($db); /* * Enable logging */ $db->logSql(); /* * Execute invalid SQL statement */ $SQL = "SELECT * FROM act where actno > 'A'"; $db->execute($SQL); $h = $perf->invalidSql(); text/html 2021-08-22T20:04:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:logsql&rev=1629662672&do=diff logSql There is a performance overhead to logging the SQL statements, use only when necessary. Syntax void logSql( optional bool $enable=true ) Description The function logSql() enables or disables the query logging facility. Upon issuance of the command, all SQL statements executed are logged to the text/html 2020-12-29T05:57:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:performance_index&rev=1609221421&do=diff Index Performance Monitoring Description 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. text/html 2024-03-21T15:14:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:suspicioussql&rev=1711034079&do=diff suspiciousSql Syntax string suspiciousSql() Description The function suspiciousSql() returns a list of SQL statements with high average execution times collected by the performance monitor logSql feature, formatted as an HTML table. Usage /* * Connection to DB2 database */ $perf = newPerfMonitor($db); /* * Enable logging */ $db->logSql(); /* * Execute suspicious SQL statement */ $SQL = "SELECT * FROM act where actno > 200"; $db->execute($SQL); $h = $perf->suspiciousSql(); print $… text/html 2016-01-20T00:28:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:performance:ui&rev=1453249700&do=diff uI Syntax string uI() Description The method uI() provides a simple graphical interface into the available commands of the performance monitor. Usage /* * Connection to database */ $perf = newPerfMonitor($db); $h = $perf->uI(); print $h; Output