<p>Sean Bright <strong>uploaded patch set #5</strong> to this change.</p><p><a href="https://gerrit.asterisk.org/7475">View Change</a></p><pre style="font-family: monospace,monospace; white-space: pre-wrap;">astdb: Improve prefix searches in astdb<br><br>Using the LIKE operator requires a full table scan of 'astdb', whereas a<br>comparison operation is able to use the primary key index.<br><br>This patch adds a new function to the AstDB API for quick prefix matches<br>and updates res_sorcery_astdb to utilize it. This showed substantial<br>performance improvement in my test environment.<br><br>Related to ASTERISK~26806, but does not completely resolve it.<br><br>Change-Id: I7d37f9ba2aea139dabf2ca72d31fbe34bd9b2fa1<br>---<br>M include/asterisk/astdb.h<br>M main/db.c<br>M res/res_sorcery_astdb.c<br>3 files changed, 107 insertions(+), 30 deletions(-)<br><br></pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;">git pull ssh://gerrit.asterisk.org:29418/asterisk refs/changes/75/7475/5</pre><p>To view, visit <a href="https://gerrit.asterisk.org/7475">change 7475</a>. To unsubscribe, visit <a href="https://gerrit.asterisk.org/settings">settings</a>.</p><div itemscope itemtype="http://schema.org/EmailMessage"><div itemscope itemprop="action" itemtype="http://schema.org/ViewAction"><link itemprop="url" href="https://gerrit.asterisk.org/7475"/><meta itemprop="name" content="View Change"/></div></div>

<div style="display:none"> Gerrit-Project: asterisk </div>
<div style="display:none"> Gerrit-Branch: 13 </div>
<div style="display:none"> Gerrit-MessageType: newpatchset </div>
<div style="display:none"> Gerrit-Change-Id: I7d37f9ba2aea139dabf2ca72d31fbe34bd9b2fa1 </div>
<div style="display:none"> Gerrit-Change-Number: 7475 </div>
<div style="display:none"> Gerrit-PatchSet: 5 </div>
<div style="display:none"> Gerrit-Owner: Sean Bright <sean.bright@gmail.com> </div>
<div style="display:none"> Gerrit-Reviewer: Corey Farrell <git@cfware.com> </div>
<div style="display:none"> Gerrit-Reviewer: Jenkins2 </div>
<div style="display:none"> Gerrit-Reviewer: Sean Bright <sean.bright@gmail.com> </div>