[asterisk-dev] RealTime, Large Dialplans, and headaches... got any ideas?

Nicholas Campion campnic at gmail.com
Tue Mar 27 16:16:10 MST 2007

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 <tilghman at mail.jeffandtilghman.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20070327/1470b515/attachment.htm

More information about the asterisk-dev mailing list