(RADIATOR) detail files: binary feature request, fast searching

[Hugh Irvine]

Hello Miguel -

I think you would get better value by setting up rotating accounting tables 
with a new table for every day, week, month or whatever and then archiving 
the old ones. That way the size of the active table stays a reasonable size.

You can use special characters for the SQL table name, or just rename the old 
one and create a new one at the end of each cycle.

regards

Hugh


On Wednesday 29 August 2001 13:08, Miguel A.L. Paraz wrote:
> What do you think of of storing the detail files in the original RADIUS
> packet form?  Then if we need to display then, look them up at the
> dictionary.  I think this would save space and speed up searching.
>
> Speaking of searching - is there a tool, or anyone have ideas, of doing
> fast lookups on detail files?  I'd like to be able to do faster lookups
> on Framed-IP-Address and a time, for tracking down abuse and the like.
> I think that a SQL database is not optimized for queries like:
>
> select USERNAME, CALLERID from RADUSAGE where TIME_STAMP > time_searched
> and TIME_STAMP - ACCTSESSIONTIME < time_searched
>
> As it just does a linear search.
> Instead, I'm thinking of building an index on the detail information
> using some sort of tree structure that will handle searching on
> extents well.  Having the detail info in binary would reduce the I/O
> required.
>
> What do you think?
>
> ===
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.