General Issues

[Alan DeKok]

On Oct 28, 2024, at 4:39 AM, mohamed almeshal <mohammed.almeshal at hotmail.com> wrote:
> What is the best max_pps that can handle heavy load , also what is best database software that can handle heavy load .

  It depends.

  That's like asking "How fast can a car go?"  Well, it depends on your budget, and what kind of road you're driving on.

  We've found Redis works well for IP pools.  LDAP works well for read-only authentication.  SQL is needed for full RADIUS accounting.

  We've also found that the database is almost always slower than FreeRADIUS.  So it's important to optimize the database schema and how you use it.

> Doing some modifications to default sites-available what is best way to implement modifications in database queries for custom purpose .

  That question is so vague that it's impossible to answer. 

  What "custom purpose" are you thinking of?  The solution will vary substantially based on what you want to do.

> Is modified the queries of the FreeRadius to lower the load like shrink the data being inserted or updated. Will effect the FreerRadius as all

  This is really a question for you.  If you aren't using data in the DB, then don't store it in the DB.  This will generally increase performance.  Perhaps not substantially, but it won't hurt.

  Alan DeKok.