At 07:38 PM 11/26/2002 +0200, Novoselsky Alexander wrote:
> > OpenRADIUS 0.9.4 7%Nope, you can edit the queries in 'sql.conf' for all versions of FreeRADIUS.
> > Navis Radius 4.2.4 9%
> > RAD-R 6.0 9%
> Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on.
May be. But OpenRADIUS and Navis Radius use simple SQL queries: "SELECT password FROM users WHERE username = ?".
It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter. But FreeRadius 0.7.1 used almost the same SQL query (it was in file sql.conf).
Try editing it and see what it does to the performance. A simpler
query ( assuming properly indexed tables, etc ) should return faster.
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
