(RADIATOR) Seeking some database advice

[Hugh Irvine]

Hello Brian -

I would be inclined to have a cron job or similar archive the data 
older than a month or two.

Other Radiator users may have other ideas.

regards

Hugh



On 9 Dec 2004, at 09:27, Brian Morris wrote:

> Hi All,
>  
> I am seeking some advice regarding the setup of the database tables 
> for Radiator.
>  
> Specifically the accounting table as it is becoming quite large indeed.
>  
> We currently have a single accounting table containing millions of 
> records which is getting pretty large.  Would it be more efficient to 
> split this table into smaller tables (say one for each month).  The 
> only reading done on this table is to display a customers detailed 
> usage history for a particular month so it would make sense to me to 
> split it into monthly chunks but I'm not sure if there would be any 
> side-effects in doing so.
>  
> Any advice would be appreciated.
>  
> Regards,  Brian.
>  
>  
>

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive 
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.