[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 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 10:15 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0115813) Hubguru (reporter) - 2009-12-29 10:15
 https://issues.asterisk.org/view.php?id=16521#c115813 
---------------------------------------------------------------------- 
patching file pbx/pbx_realtime.c
Hunk https://issues.asterisk.org/view.php?id=1 succeeded at 33 with fuzz 2
(offset 6 lines).
Hunk https://issues.asterisk.org/view.php?id=2 FAILED at 55.
Hunk https://issues.asterisk.org/view.php?id=3 succeeded at 65 with fuzz 2.
Hunk https://issues.asterisk.org/view.php?id=4 FAILED at 215.
Hunk https://issues.asterisk.org/view.php?id=5 FAILED at 237.
Hunk https://issues.asterisk.org/view.php?id=6 FAILED at 396.
4 out of 6 hunks FAILED -- saving rejects to file pbx/pbx_realtime.c.rej

I'm patching against 1.4.28 stable release.  Did you create this patch
against trunk? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-12-29 10:15 Hubguru        Note Added: 0115813                          
======================================================================