On 5/21/07, Nathan Nobbe <[EMAIL PROTECTED]> wrote:
efficient; triggers could be employed (im using mysql 5+) to update a table, call it recent_tables_that_changed, dedicated to signifying particular tables in the database have changed. then the cron'd php script could simply check recent_tables_that_changed to determine which, if any, application variables had become stale (do to a change in data profile). the stale variable could then be updated and the record removed from recent_tables_that_changed.
I am using an approach similar to this, but not for memcached. I am using APC (which is much faster) for local cache storage, so we need to use trigger as a way to clean cache on remote servers. -- Best Regards, tszming
