<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<div>: Info: Request Start time is 4440538</div><div> User-Name = 12345678</div><div> Movie-ID = 5</div><div> Group-ID = 0</div><div> ACCT TYPE = 1</div><div> CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret</div><div> Return Code = 1</div><div> REQUEST END TIME IS 4440685</div><div> Process time IS = 147</div><div> Acct_Nulti Session ID = ngi</div><div>Tue Oct 16 01:14:05 2012</div><div>: Info: Request Start time is 4440538</div><div> User-Name = <span style="font-size: 10pt; ">12345678</span></div><div> Movie-ID = 5</div><div> Group-ID = 0</div><div> ACCT TYPE = 1</div><div> CALL Proc_Ngi_Acc_Stop_IPTV( '12345678', '5','0','1', @ret ); select @ret</div><div> Return Code = 0</div><div> REQUEST END TIME IS 4445686</div><div> Difference of time IS 5148</div><div>Tue Oct 16 01:14:05 2012</div><div>: Info: Request Start time is 4440541</div><div> User-Name = <span style="font-size: 10pt; ">12345678</span></div><div> Movie-ID = 5</div><div> Group-ID = 0</div><div> ACCT TYPE = 1</div><div> CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret</div><div> Return Code = 1</div><div> REQUEST END TIME IS 4445696</div><div> Process time IS = 5155</div><div> Acct_Nulti Session ID = ngi</div><div>Tue Oct 16 01:14:05 2012</div><div><br></div><div><br></div><div><br></div><div>i am sending values procedures "<span style="font-size: 10pt; ">CALL Proc_Ngi_Acc_Start_IPTV</span><span style="font-size: 10pt; ">" and "</span><span style="font-size: 10pt; ">CALL Proc_Ngi_Acc_Stop_IPTV</span><span style="font-size: 10pt; ">" </span><span style="font-size: 10pt; "> and this is procedues return time... but if this is db issue thn why other queries taking arround 100 miliseconds... </span></div><br><div><div id="SkyDrivePlaceholder"></div>> Date: Wed, 17 Oct 2012 12:19:34 +0700<br>> Subject: Re: Radius Perfomance Issure<br>> From: list@fajar.net<br>> To: freeradius-users@lists.freeradius.org<br>> <br>> On Wed, Oct 17, 2012 at 12:07 PM, QASIM RAO <qasim2490@hotmail.com> wrote:<br>> > hi,<br>> > i am testing performance of my Freeradius using java multi threading and i<br>> > am facing an issue<br>> ><br>> > normaaly acounting start procedure taking less then 1000 miliseconds. and<br>> > this is my requirment<br>> ><br>> > but after some requests free radius takes more then 5000 miliseconds<br>> > continusly then returns normally...<br>> <br>> <br>> > please help me in this what is wrong in this why it take so long time<br>> <br>> <br>> What backend did you use for accounting?<br>> <br>> If files, then there's no reason for it to be that slow.<br>> <br>> If you store accounting data on db, then fix your db, cause that's<br>> where the bottleneck is.<br>> <br>> -- <br>> Fajar<br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></div> </div></body>
</html>