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
