: 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 = ngi
Tue 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 5148
Tue 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 = ngi
Tue 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@fajar.net
> To: freeradius-users@lists.freeradius.org
>
> On Wed, Oct 17, 2012 at 12:07 PM, QASIM RAO <qasim2490@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