[asterisk-bugs] [JIRA] (ASTERISK-26061) [patch] res_pjsip: improve realtime performance - remove updating all endpoints status on startup

[JoshE (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-26061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=231175#comment-231175 ] 

JoshE edited comment on ASTERISK-26061 at 6/26/16 2:33 PM:
-----------------------------------------------------------

Alexei-

This is definitely a needed patch.  We've been working on something similar for a project on our end.

I think we'd propose taking this a bit further.  We have a database of roughly 20,000 endpoints and AORs.  They'reall qualified, so we are still seeing 20,000 SQL lookups on startup.

DEBUG[1106] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id

Boot to Asterisk Ready with this patch takes us around 10 minutes per server, which is far better than 13.10 boot time of 15 minutes and 13.9 or earlier of 30+ minutes.

I think we'd like to propose adding a knob that that would allow us to disable the contacts lookup, regardless of the qualify condition.  Probably not appropriate for a number of use cases, but for larger "unified" clusters, where we would like to have every endpoint able to register to any node, it seems like this may be a good solution.

Thoughts there?


was (Author: n8ideas):
Alexei-

This is definitely a needed patch.  We've been working on something similar for a project on our end.

I think we'd propose taking this a bit further.  We have a database of roughly 20,000 endpoints and AORs.  The AORs are all qualified, so we are still seeing 20,000 SQL lookups on startup.

DEBUG[1106] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id

Boot to Asterisk Ready with this patch takes us around 10 minutes per server, which is far better than 13.10 boot time of 15 minutes and 13.9 or earlier of 30+ minutes.

I think we'd like to propose adding a knob that that would allow us to disable the contacts lookup, regardless of the qualify condition.  Probably not appropriate for a number of use cases, but for larger "unified" clusters, where we would like to have every endpoint able to register to any node, it seems like this may be a good solution.

Thoughts there?

> [patch] res_pjsip: improve realtime performance - remove updating all endpoints status on startup
> -------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-26061
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26061
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_pjsip
>    Affects Versions: 13.9.1
>            Reporter: Alexei Gradinari
>
> This patch removes updating all Endpoints' status on startup.
> The endpoint status should be updated by 'qualify' functions.
> The 'qualify' functions are already patched to improve performance.



--
This message was sent by Atlassian JIRA
(v6.2#6252)