<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Just an in-general performance hint: Get your setup running,
then use the SQL Profiler to generate a tuning trace, and run the “Database
Engine Tuning Advisor” with it. That way it’ll tell you which
indexes you need (or need to drop) to optimize the database side of
performance. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>500 simultaneous calls isn’t much though. Even with 30
second nibblebillings, that’s only 16 updates/sec – and your
calls/sec is probably lower than that. That’s not too much work for any average
server these days, even doing dialplan/cdr/billing against remote SQL. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Michael<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
freeswitch-users-bounces@lists.freeswitch.org
[mailto:freeswitch-users-bounces@lists.freeswitch.org] <b>On Behalf Of </b>Manu<br>
<b>Sent:</b> Sunday, August 16, 2009 2:05 AM<br>
<b>To:</b> freeswitch-users@lists.freeswitch.org<br>
<b>Subject:</b> Re: [Freeswitch-users] mod nibblebill question<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Thank you for the reply Michael. Let me ask your opinion on
another related matter also.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I am using a MS SQL Database (which will be there on a
remote server). I wish to keep ...<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>1- User database in SQL.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>2- Dialplans in SQL.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>3- CDR logged in SQL.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>4- I also require to cut the call in real time when credit
is over.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I want to deply this to get good performance for 500 calls
simultaneous. I see in documents that using http responses i can fetch data
from my web server. I figure i can return number of gateways and other
dial plan parameters this way. In the same HTTP request i can also return
"call Rates" for the called destination (which i can use in
nibble)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Is there any other efficiant apprroach you can suggest?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Regards,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Manoj<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>On Sun, Aug 16, 2009 at 2:50 AM, Michael Jerris <<a
href="mailto:mike@jerris.com">mike@jerris.com</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>increments are in seconds, not microseconds. In IMS
for example I<br>
think it defaults to 20 or 30 second nibbles, depending on your<br>
tolerances and billing increments something much larger may even make<br>
sense. Doing billing in sub second increments doesn't make a lot of<br>
sense to me. Remember that this is just keeping track of available<br>
credit so if there are multiple calls at the same time you won't go<br>
over balance. Everything is still reconciled at hang up, so if you<br>
have a bit too much reserved from your nibble the worst that could<br>
happen is it could cut off calls a little too early when multiple<br>
calls are in progress on the same account.<br>
<br>
Mike<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
On Aug 15, 2009, at 3:33 PM, Manu wrote:<br>
<br>
> Hello,<br>
><br>
> If we use heartbeat option on in nibblebill.conf.xml does that mean<br>
> ODBC database table will be updated every microsecond or any other<br>
> interval we set?<br>
><br>
> If this is so and there are many users (Lets say 500 users) are<br>
> connected to FS wouldn't it create locking issues in DB?<br>
><br>
> Regards,<br>
><br>
> Manoj<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>