17 May
2007
17 May
'07
6:40 p.m.
On Thu 17 May 2007, A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Unless you are doing monthly or yearly summary reports which can take a lightly loaded DB server and peg it for minutes at a time...
The lesson.. Keep a second DB for reporting :-)
or use a DB that can handle non-blocking selects? <ducks> ;-)
I use PostgreSQL... I didnt say that it stops the DB or queries.. Just that it "works" it in a way the FreeRADIUS will not. If the report is big enough and you have a heavy enough RADIUS load, it _can_ be enough load to push your box over the limit and start timing out requests... -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc