On 22/10/09 6:52 PM, das sandesh wrote:
> There were 2 problems that we faced, one was at around 50 calls, few
> calls were just dead air, and when I saw the logs I could see that it
> was sent to the sip provider and after that there was no log for that
> particular call that was having dead air, but at around 200 to 250, we
> could see that MySQL(Connect connid <ipaddr> uname pwd db) statement
> took around 5-10 sec to connect to the database and then the 2 queries
> in that code got executed pretty fast (1-2sec), and so here we had the
> dead air untill the call got connected (after 5-10sec).

1-2 seconds for a query isn't really that quick.

You might also want to do

explain SQLSTATEMENT

where SQLSTATEMENT is the SQL query you are running.

-- 
Cheers,

Matt Riddell
Director
_______________________________________________

http://www.venturevoip.com/news.php (Daily Asterisk News)
http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer)
http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems)

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to