Radius Perfomance Issure

[QASIM RAO]

: Info: Request Start time is 4440538 User-Name =  12345678 Movie-ID =  5 Group-ID =  0 ACCT TYPE =  1 CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret Return Code =  1 REQUEST END TIME IS 4440685 Process time  IS = 147 Acct_Nulti Session ID = ngiTue Oct 16 01:14:05 2012: Info: Request Start time is 4440538 User-Name =  12345678 Movie-ID =  5 Group-ID =  0 ACCT TYPE =  1 CALL Proc_Ngi_Acc_Stop_IPTV( '12345678', '5','0','1', @ret ); select @ret Return Code =  0 REQUEST END TIME IS 4445686 Difference of time  IS 5148Tue Oct 16 01:14:05 2012: Info: Request Start time is 4440541 User-Name =  12345678 Movie-ID =  5 Group-ID =  0 ACCT TYPE =  1 CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret Return Code =  1 REQUEST END TIME IS 4445696 Process time  IS = 5155 Acct_Nulti Session ID = ngiTue Oct 16 01:14:05 2012


i am sending values procedures  "CALL Proc_Ngi_Acc_Start_IPTV" and  "CALL Proc_Ngi_Acc_Stop_IPTV"   and this is procedues return time... but if this is db issue thn why other queries taking arround 100 miliseconds... 
> Date: Wed, 17 Oct 2012 12:19:34 +0700
> Subject: Re: Radius Perfomance Issure
> From: list at fajar.net
> To: freeradius-users at lists.freeradius.org
> 
> On Wed, Oct 17, 2012 at 12:07 PM, QASIM RAO <qasim2490 at hotmail.com> wrote:
> > hi,
> > i am testing performance of  my Freeradius using java multi threading and i
> > am facing an issue
> >
> > normaaly acounting start procedure taking less then 1000 miliseconds. and
> > this is my requirment
> >
> > but after some requests free radius takes more then 5000 miliseconds
> > continusly then returns normally...
> 
> 
> > please help me in this what is wrong in this why it take so long time
> 
> 
> What backend did you use for accounting?
> 
> If files, then there's no reason for it to be that slow.
> 
> If you store accounting data on db, then fix your db, cause that's
> where the bottleneck is.
> 
> -- 
> Fajar
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121017/7908e163/attachment.html>