Alan DeKok wrote:
Alexander Serkin <[EMAIL PROTECTED]> wrote:
I know of Oracle installations with 400k users. And the default
schema works with installations of millions of users.
do you mean 400k active simultaneous connections? And do they use
accounting updates (Interim-Update records)?
There are no simultaneous connections in RADIUS.
Oh, sorry. I didn't mean simultaneous connections. I meant the amount of
online users. We have up to ~4500 online connections for ~170k subscribers.
I mean 400k users, many of whom are online at the same time, and
sending accounting updates.
The table is about 37 million records since april 2005.
Is it indexed?
yes it is indexed by all columns which take part in "where" clauses of
the select and update queries.
And why do you have a years worth of data available to your RADIUS
server? It's completely unnecessary.
You may need a years worth of data available for your billing
software, and long-term records, but those things don't need one
second response time. Change your tables so that you have "current"
data (i.e. last month or so) available to FreeRADIUS, and leave the
year-old data in another table that the server doesn't use.
We will. This is subject to discuss with our DBAs.
Thanks for your comments, Alan.
--
Sincerely Yours,
Alexander
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
