Re: [SR-Users] Mysql to hastable conversion

2019-02-13 Thread Ovidiu Sas
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  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@lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



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

___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


[SR-Users] Mysql to hastable conversion

2019-02-13 Thread Duarte Rocha
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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users