Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-12-01 Thread Tomas Andersen
ng list Date: Monday 30 November 2015 at 16:19 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi, As for the usability questions, from trusted peers it matches the ip to a reseller so this can be billed. The subscriber table is used to find the RPID fr

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
Hi again. I have set up wireshark to check why the CDR rating engine uses so much time. The following SQL queries are run from CDRTool to my OpenSIPS server: select * from domain; select * from trusted_peers; Select rpid from subscriber where username = ‘+47’ and domain =

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tijmen de Mes
> From: <users-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org>> on behalf of Tomas Andersen > Reply-To: OpenSIPS users mailling list > Date: Monday 30 November 2015 at 13:31 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] CDR s

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tijmen de Mes
Hi Tomas, That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to determine the flow of the calls. After the query is executed in CDRTool, more logic follows. It can easily be that the delay is in there. If web normalizing is enabled and the

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
en de Mes Reply-To: OpenSIPS users mailling list Date: Monday 30 November 2015 at 13:01 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi Tomas, That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to det

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
oun...@lists.opensips.org<mailto:users-boun...@lists.opensips.org>> on behalf of Tomas Andersen Reply-To: OpenSIPS users mailling list Date: Monday 30 November 2015 at 13:31 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi. Thank you for responding. I ha

[OpenSIPS-Users] CDR search slow in CDRTool

2015-11-27 Thread Tomas Andersen
Hi I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. I am successfully rating calls, but everytime I search for CDR records using the CDRTool GUI it takes 1-3 minutes before the search result window is shown. If there are no matching records the result window is