You could create another table in the database that would hold the last write times of these tables. Create a separate table with the columns "table name" and "mod date", then create or modify the wrapper which you use to write information to the RT tables to, before they write to the appropriate real time table, update the time in the mod access time for that table to the current time. Then, when a call comes in, check that table entry and see if it needs to be reloaded.
I don't know if that makes this a good idea, but it seems possible. On 3/27/07, Tilghman Lesher <[EMAIL PROTECTED]> wrote:
On Tuesday 27 March 2007 16:06, Luigi Rizzo wrote: > Googling a bit, it seems that you can get the modification date of > a database table with a "SHOW TABLE STATUS" query, and this would > at least help to know if the cache is in sync. That does not appear to be portable. Postgres, for example, has no such command. -- Tilghman _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-dev mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev
_______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-dev mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev
