Summary:	ASTERISK-28077: res_pjsip: improve realtime performance on CLI 'pjsip show contacts'
Reporter:	Alexei Gradinari (alexei gradinari)	Labels:	pjsip
Date Opened:	2018-09-25 17:32:21	Date Closed:	2018-10-01 06:51:39
Priority:	Minor	Regression?
Status:	Closed/Complete	Components:	Resources/res_pjsip
Versions:	13.23.1	Frequency of Occurrence
Related Issues:
Environment:		Attachments:
Description:	CLI command 'pjsip show contacts' inefficiently make a lot of DB requests. For example if there are 10k aors then asterisk requests these 10k records of aor and then does 10k requests of contact - one request per aor. Even if use 'like <pattern>' the asterisk requests all aor's and contact's records and then filtered them by itself. Better to request dynamic contacts directly and request only aors with permanent contacts.
Comments:	By: Asterisk Team (asteriskteam) 2018-09-25 17:32:23.880-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Friendly Automation (friendly-automation) 2018-10-01 06:51:40.332-0500 Change 10270 merged by Joshua Colp: res_pjsip: improve realtime performance on CLI 'pjsip show contacts' [https://gerrit.asterisk.org/10270|https://gerrit.asterisk.org/10270] By: Friendly Automation (friendly-automation) 2018-10-01 06:52:01.496-0500 Change 10324 merged by Joshua Colp: res_pjsip: improve realtime performance on CLI 'pjsip show contacts' [https://gerrit.asterisk.org/10324|https://gerrit.asterisk.org/10324] By: Friendly Automation (friendly-automation) 2018-10-01 06:52:24.159-0500 Change 10325 merged by Joshua Colp: res_pjsip: improve realtime performance on CLI 'pjsip show contacts' [https://gerrit.asterisk.org/10325|https://gerrit.asterisk.org/10325] By: Friendly Automation (friendly-automation) 2018-10-01 06:59:05.164-0500 Change 10323 merged by Joshua Colp: res_pjsip: improve realtime performance on CLI 'pjsip show contacts' [https://gerrit.asterisk.org/10323|https://gerrit.asterisk.org/10323]