telling code to pull from the database when the data in a table
Tsz Ming WONG
tszming at gmail.com
Mon May 21 14:46:22 UTC 2007
On 5/21/07, Nathan Nobbe <quickshiftin at gmail.com> 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
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.
More information about the memcached