ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:clearsql

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

  • The command may time out if run in a browser
  • The command may place the system under a heavy load, and there may be transactional timeout issues on some DBMS

An alternative methodology is:

  1. Stop the logging system
  2. Use a 'truncate table' command
  3. restart the logging system
v5/performance/clearsql.txt · Last modified: 2016/01/13 02:14 by mnewnham