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

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
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 review
Asterisk Version:           SVN 
JIRA:                       SWP-1476 
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:              2010-05-27 14:25 CDT
====================================================================== 
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.
====================================================================== 

---------------------------------------------------------------------- 
 (0122582) svnbot (reporter) - 2010-05-27 14:25
 https://issues.asterisk.org/view.php?id=16521#c122582 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 266238

U   trunk/CHANGES
U   trunk/pbx/pbx_realtime.c

------------------------------------------------------------------------
r266238 | tilghman | 2010-05-27 14:25:16 -0500 (Thu, 27 May 2010) | 11
lines

Cache query results for one second.

Queries from the PBX core come in 3's.  Caching avoids the additional
performance penalty from those two additional queries hitting the
database.

(closes issue https://issues.asterisk.org/view.php?id=16521)
 Reported by: tilghman
 Patches: 
       20091229__issue16521.diff.txt uploaded by tilghman (license 14)
 Tested by: Hubguru, tilghman

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=266238 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-05-27 14:25 svnbot         Checkin                                      
2010-05-27 14:25 svnbot         Note Added: 0122582                          
======================================================================