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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html