<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Why do you need microseconds in accounting? All database queries, round trip time to the database on the LAN, radius requests, all add up times impossible to measure. What is the point of accounting microseconds for a process that itself takes unknown amount of time but several order of magnitude higher than your accounting resolution?<div><div><br></div><div>Adrian</div><div><br></div><div><div><div>On Jan 24, 2011, at 9:47 PM, Dave Singer wrote:</div><div><div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Thanks for that clarification!</div><div><br></div>So just to be sure I'm clear on this. $Ts rounds down ( truncates ) the current second. So using $avp(s:start_time) = $Ts.$Tsm; would give something like "12343253.543233" and always be accurate?<div>
Further (<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">standard ACC [without dialog]) </span>you could just put $Tsm in the db_extras as an extra column and then use the tool you are using to created cdrs from the acc table to take the column with the $Tsm value into account when calculating duration, ringtime, etc.</div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div>To get these numbers with the new CDR feature, you would have to store a dialog variable like $dlg_val("start") = "$Ts.$Tsm" at start and $dlg_val("answered") = "$Ts.$Tsm" at answer and at the end of the call add them db_extras along with $Ts.$Tsm for the end of the call. You would then want to go off of those numbers rather than what the acc module automatically put in the db.</div>
<div>The disadvantage would be having duplicate columns for start/answer/end times but you would still have the benefit of not having to have an external process building cdrs from acc table matching up BYEs to INVITES, etc.</div>
<div>Calculating the durations in opensips would be tricky since it does not work with non integers. But you could do that easily with a sql trigger on the record insert.</div><div><br></div><div>Does this sound right?</div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br></div><div>Thanks</div><div>Dave</div><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta http-equiv="content-type" content="text/html; charset=utf-8"><div>
<br><div class="gmail_quote">On Thu, Jan 20, 2011 at 4:54 AM, Anca Vamanu <span dir="ltr"><<a href="mailto:anca@opensips.org">anca@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 01/19/2011 09:31 PM, <a href="mailto:a.zagorskiy@oyster-telecom.ru" target="_blank">a.zagorskiy@oyster-telecom.ru</a> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
It was my conversation, and I told about<br>
1) $Tsm is MICROseconds (6 digits)<br>
2) It is microseconds of a current second.<br>
<br>
</blockquote></div>
Yes, that's true. I fixed it in documentation also.<br><font color="#888888">
<br>
-- <br>
Anca Vamanu<br>
<a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a></font><div><div></div><div class="h5"><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></blockquote></div><br></div></div></div></div></body></html>