[Spce-user] CE MR 3.2.1 - API response times when calling "add_voip_account_subscriber" function.

[Joel Smith | VOZELIA]

Hi again, 

Could the problem be having 17k subscribers under the same account?

Maybe the correct way should be to have a separate account for each subscriber. (Although that doesn't make too much sense)

The users are created with minimum info:

SIP User
SIP Pass
External #ID


That is it, no numbers defined, no alias, etc.


I really don't understand, any ideas are more than welcome!!


Thank you in advanced.

Best regards, 
Joel.




----- Original Message -----
> From: "Joel Smith | VOZELIA" <joel at vozelia.com>
> To: "Spce-user" <spce-user at lists.sipwise.com>
> Sent: Friday, April 11, 2014 4:50:41 PM
> Subject: Re: CE MR 3.2.1 - API response times when calling "add_voip_account_subscriber" function.
> 
> Hi,
> 
> This is getting worse. I've tried the NGCP's own script to create a
> subscriber:
> 
> 
> root at spce1:/usr/bin# time ./ngcp-create_subscriber -v 5 -u joel -d
> sip.testdomain.com -p joeljoel
> Added subscriber to VoIP account 5.
> 
> real        2m15.588s
> user        1m14.449s
> sys        0m8.893s
> root at spce1:/usr/bin#
> 
> 
> Can anybody guide me how to debug problems with the
> "add_voip_account_subscriber" function?
> 
> Any other request takes not even a second (example: update password, set
> adm_block_mode_out, etc.)
> 
> 
> Any idea on what can be happening?
> 
> Best regards,
> Joel.
> 
> 
> 
> 
> ----- Original Message -----
> > From: "Joel Smith | VOZELIA" <joel at vozelia.com>
> > To: "Spce-user" <spce-user at lists.sipwise.com>
> > Sent: Thursday, April 10, 2014 2:57:05 PM
> > Subject: CE MR 3.2.1 - API response times when calling
> > "add_voip_account_subscriber" function.
> > 
> > Hi,
> > 
> > We are experiencing a huge delay on the time the API takes to create a new
> > subscriber.
> > 
> > We have to create around 20k subscribers. At the beggining the creation was
> > very fast, as the number of existing subscribers grows the create execution
> > slows down.
> > 
> > The server is not in production yet so there should be no load issues.
> > 
> > 
> > At the moment it takes around 8-9seconds to create a subscriber:
> > 
> > root at spce1:~# time ./test_adduser.php user1
> > OK
> > 
> > real        0m8.194s
> > user        0m0.016s
> > sys        0m0.008s
> > root at spce1:~#
> > 
> > 
> > root at spce1:~# time ./test_adduser.php user2
> > OK
> > 
> > real        0m9.156s
> > user        0m0.024s
> > sys        0m0.004s
> > root at spce1:~#
> > 
> > 
> > 
> > The adduser code is really simple:
> > 
> > root at spce1:~# cat test_adduser.php
> > #!/usr/bin/php
> > <?php
> >         $soap_url = "https://127.0.0.1:2443/SOAP/Provisioning.wsdl?plain";
> >         $auth = array('username' => 'testuser',
> >                                 'password' => 'testpass',
> >                                 'type' => 'admin');
> > 
> >         $client_options = array('login' => 'ngcpsoap',
> >                                                         'password' =>
> >                                                         'ngcptestpass');
> > 
> >         $params1 = array('id' => 5,
> >                                         'subscriber' => array(
> >                                                                 "username"
> >                                                                 =>
> >                                                                 $argv[1],
> >                                                                 "domain" =>
> >                                                                 "sip.testdomain.com",
> >                                                                 "password"
> >                                                                 =>
> >                                                                 "hjklpojH"
> >                                                         )
> >                                         );
> > 
> >         try{
> >                 $client = new SoapClient($soap_url, $client_options);
> >                 $ret1 = $client->add_voip_account_subscriber($auth,
> >                 $params1);
> >                 echo "OK \n";
> >         } catch (SoapFault $exception) {
> >                 echo $exception."\n";
> >         }
> > ?>
> > root at spce1:~#
> > 
> > 
> > Is there anything I can check to see why it takes soooooooooooo long to
> > create?
> > 
> > If I create a subscriber through the GUI, it takes 0seconds.
> > 
> > 
> > Another thing to say, for each subscriber we create, we set the
> > adm_block_out_mode to TRUE, this also takes 0sec (through the API) so the
> > problem is directly related to add_voip_account_subscriber.
> > 
> > 
> > Any idea on this? Please let me know if there is more information required
> > to
> > search for the root cause of this problem.
> > 
> > 
> > Thanks in advanced.
> > 
> > Best regards,
> > Joel.
> > 
> >