asterisk users - Jun 2018 - Asterisk Realtime PJSIP - slow output on "pjsip show xxxxx" commands

Hi all!

I have an Asterisk instance (15.4.1) with a MySQL DB in realtime configuration
(using MySQL ODBC connector).

I noticed, that when I issue “pjsip show endpoints” in the CLI this takes
forever (on average about 1 minute with 1029 entries in ps_endpoints table).
If I query the database over the same ODBC connector with isql, this takes less
than a second.

I have enabled caching in sorcery.conf but it doesn’t really help (at least not
concerning the output of “pjsip show xxxxx” commands).

Any idea what might be causing this and how I can optimize it?



With best regards

Florian Floimair
Innovation - Software-Development

COMMEND INTERNATIONAL GMBH
A-5020 Salzburg, Saalachstraße 51
http://www.commend.com<http://www.commend.com/>

Security and Communication by Commend

FN 178618z | LG Salzburg

From: asterisk-users <asterisk-users-bounces at lists.digium.com> on
behalf of David P <davidswalkabout at gmail.com>
Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Date: Monday, 18. June 2018 at 04:26
To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users
at lists.digium.com>
Subject: Re: [asterisk-users] Only 8kHz recorded after disallowing all but G722
codec on inbound

I also just tried adding this:

 same => n,Set(SIP_CODEC_INBOUND=g722)

On Sat, Jun 16, 2018 at 4:36 PM David P <davidswalkabout at
gmail.com<mailto:davidswalkabout at gmail.com>> wrote:
We want to record inbound channels at 16kHz, but send only 8kHz to our peers.
I've set our default profile in sip.conf to disallow all but g722, and the
peers disallow all but ulaw. We have a proxy in front of Asterisk that is
configured to disallow all but G722 also.

My test calls show inbound to the proxy is recorded at 16kHz, inbound in
Asterisk is only 8kHz, and the peers receive 8kHz. So the only thing not working
is Asterisk's sampling rate on inbound, and it seems to be downsampling.

After a lot of web searching, I can't find any explanation of why we're
not getting 16kHz for G722. We're using Asterisk 14.7.6.

Cheers,
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20180618/b63af853/attachment.html>