Skip to content
Snippets Groups Projects
  • Sean Bright's avatar
    9a9edc6c
    astdb: Improve prefix searches in astdb · 9a9edc6c
    Sean Bright authored
    Using the LIKE operator requires a full table scan of 'astdb', whereas a
    comparison operation is able to use the primary key index.
    
    This patch adds a new function to the AstDB API for quick prefix matches
    and updates res_sorcery_astdb to utilize it. This showed substantial
    performance improvement in my test environment.
    
    Related to ASTERISK~26806, but does not completely resolve it.
    
    Change-Id: I7d37f9ba2aea139dabf2ca72d31fbe34bd9b2fa1
    9a9edc6c
    History
    astdb: Improve prefix searches in astdb
    Sean Bright authored
    Using the LIKE operator requires a full table scan of 'astdb', whereas a
    comparison operation is able to use the primary key index.
    
    This patch adds a new function to the AstDB API for quick prefix matches
    and updates res_sorcery_astdb to utilize it. This showed substantial
    performance improvement in my test environment.
    
    Related to ASTERISK~26806, but does not completely resolve it.
    
    Change-Id: I7d37f9ba2aea139dabf2ca72d31fbe34bd9b2fa1