I have a problem with SQL queries that taking a *huge* length of time and i need to replace the UPDATE statement by INSERT My SQL table is 1.000.000 entries and an UPDATE statement take 1 or 2 minutes long. Too long for authentication.
Alan said that indexing the table would help. I don't know how indexing works. Can somebody write a little tutorial on indexing SQL tables to be used with freeradius ? ----- Original Message ----- From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 8:44 AM Subject: Re: Radius error > "Justin Ainsworth" <[EMAIL PROTECTED]> wrote: > > Would it be possible to make it so radiusd will refuse packets when it > > is out of sockets, instead of dieing? > > Yes, but that wouldn't help. > > The problem is that your SQL queries are taking a *huge* length of > time. That's why the server is locking. > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
