: 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@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