[asterisk-users] Asterisk Realtime PJSIP - slow output on "pjsip show xxxxx" commands

[Floimair Florian]

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>