[SR-Users] Mysql to hastable conversion

Ovidiu Sas osas at voipembedded.com
Wed Feb 13 18:18:14 CET 2019


Hello Duarte,

Create a view for each htable that you want to use.
Like this you can keep you existing table and config tools.

Regards,
Ovidiu Sas

On Wed, Feb 13, 2019 at 12:14 PM Duarte Rocha <duarterocha91 at gmail.com> wrote:
>
> Greetings,
>
> I have Kamailio has an SBC and i'm using a MySQL database to store all the relevant configurations and settings regarding the NAP's, Users, Numbers, etc.
>
> That being said, i'm having lots of of performance issues originated by the queries. In order to solve that i think the best way to proceed would be to implement hashtables. However, i would like to keep Sql DB's for easier configuration and having them automatically transformed into hashtables.
>
> Is there a simple way to do this? As i see, the htable module is able to load from a DB, but i understand it, the table should be already in "hashtable form".
>
> Does kamailio has any way to solve this or should i use external tools?
>
> Best Regards,
>
> Duarte Rocha
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com



More information about the sr-users mailing list