[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 11:31 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0115821) Hubguru (reporter) - 2009-12-29 11:31
 https://issues.asterisk.org/view.php?id=16521#c115821 
---------------------------------------------------------------------- 
Tilghman,

Saying I’m a bit excited right now is an understatement.  First of all,
the patch seems to work fine applied to 1.4.28 stable release.  The
performance of this patch is extraordinary.  Before migrating my static
dialplan to the database I could push
https://issues.asterisk.org/view.php?id=121#c380 calls at 15 to 20 CPS.  After
migrating to the database, I could only push a little more than 100 calls
and no more than 6 to 9 CPS.  With this patch applied, I am pushing
reliably 300 calls at 15 CPS. 7500+ calls without a hiccup.  Not quite as
good as a static dialplan, but that is expected.  MySQLd has also decreased
utilization, as expected, from 6 to 12, now 1 to 6.  This has got to be an
overall performance increase by 50% or more.

I will be patching on my new 1.4 systems going forward.  The sooner this
patch gets applied to Asteisk, the better.

Thanks.

JR 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-12-29 11:31 Hubguru        Note Added: 0115821                          
======================================================================