Free Radius performance variation

[Mark Dennehy]

That wouldn't be hugely surprising if your database wasn't well set up, to
be honest.

On Wed, Dec 16, 2009 at 2:41 PM, Tejesh Vijayakumar <
Tejesh.Vijayakumar at lntinfotech.com> wrote:

> Thanks Alan for the suggestion..
>
> My main query was why the difference of 45 [125 auth/sec - 80 auths/sec].
> The no of auths per sec is dropping at a fast rate as the number of users
> are increasing. How to make that consistent upto some point say for atleast
> one million users. [i.e auths/sec would be almost same for no of users upto
> one million users].
>
>
> ________________________________________
> From: freeradius-devel-bounces+tejesh.vijayakumar=lntinfotech.com@
> lists.freeradius.org [freeradius-devel-bounces+tejesh.vijayakumar=
> lntinfotech.com at lists.freeradius.org] On Behalf Of Alan Buxey [
> A.L.M.Buxey at lboro.ac.uk]
> Sent: Wednesday, December 16, 2009 11:17 PM
> To: FreeRadius developers mailing list
> Subject: Re: Free Radius performance variation
>
> Hi,
>
> > I have tried PAP Authentication using users file and users stored in
> PGSQL Database.
> > With the users file Iam getting 125 auths/sec and 80auths/sec for 1000
> and 10000 users respectively.
> > With SQL database the figures are 105 auths/sec and 70 auths/sec for 1000
> and 10000 users respectively.
> > My query is why there is no consistency in auths/sec between 1000 and
> 10000 users and how to make it consistent or atleast nearby figures.
>
> for users file you might get better performance moving to the 'fastusers'
> module which hashes
> the entries?
>
> for the SQL - if you have more records then it takes longer to find entries
> in the database!
> this is basic database stuff - you need to index the required columns that
> you want good results
> from - recommend douglas and douglas postgres book - published by
> Developers library - or
> just the main posgres documentation from their site. this isnt a FreeRADIUS
> problem
>
> alan
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/devel.html
>
> ______________________________________________________________________
>
> This Email may contain confidential or privileged information for the
> intended recipient (s) If you are not the intended recipient, please do not
> use or disseminate the information, notify the sender and delete it from
> your system.
>
> ______________________________________________________________________
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/devel.html
>



-- 
Mark Dennehy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20091216/15791752/attachment.html>