Hi, I would like to implement a query tracker in Zend_Db for some tables.The idea is to store in db an history of all SQL queries that were executed on these tables.
Here is the kind of table schema I would like to populate with it:
CREATE TABLE table_history (
id TIMESTAMP NOT NULL PRIMARY KEY,
tablename CHAR(64),
query VARCHAR(...)
);
I was thinking of using db profiling mechanism to do it. What would you
suggest?
-- Guillaume ORIOL
