freeradius with mssql performance

[Peter Nixon]

On Tue 13 Mar 2007 12:09, satish patel wrote:
> Dear guys
>
>              anybody idea of freeradius with MSSQL compatibliy or
> performance issue ......which is best of method with radius MySql or MSSQL
> which one is best for radius performance

Satish

You are likely to get slightly better performance with MySQL or Postgresql 
than with MSSQL due to the extra driver layers required to get to a MSSQL 
server. Pretty much everything else it up to the database systems 
themselves, the table structures you use and the queries you use. In my 
experience Postgresql is by far the preferred DB engine for use with 
FreeRADIUS (It has native INET types and brilliant datetime support) but 
your experiences will vary depending on how you use it. As with any 
database, indexing the queries you run frequently is critical for 
performance!

You will certainly get MUCH LESS support from the list by using MSSQL as very 
few people use it in comparison to MySQL and Postgresql.

Regards

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc