[asterisk-bugs] [Asterisk 0016521]: [patch] Optimize queries to cache matches

[Asterisk Bug Tracker]

The following issue is now READY FOR TESTING. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16521 
====================================================================== 
Reported By:                tilghman
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16521
Category:                   PBX/pbx_realtime
Reproducibility:            N/A
Severity:                   feature
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 236434 
Request Review:              
====================================================================== 
Date Submitted:             2009-12-29 01:11 CST
Last Modified:              2009-12-29 01:12 CST
====================================================================== 
Summary:                    [patch] Optimize queries to cache matches
Description: 
A long-running problem of the Realtime Extensions driver has been that it
runs the same query 3 times for each extension priority, which is
incredibly inefficient.  JR Richardson noted this in a recent post,
thinking that it was a bug or a problem on his end.

Hence, I introduce caching for realtime extensions of 1 second, which is
more than enough to cut out these extra sets of queries, but not so long as
to make the realtime extensions no longer quite realtime.
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-12-29 01:12 tilghman       Status                   new => ready for
testing
======================================================================