[ic] User tracking

[Stefan Hornburg]

On Thu, 21 Oct 2004 11:53:27 +0100
Jamie Neil <jamie at versado.net> wrote:

> I've found the usertrack file very useful for both troubleshooting and 
> generating accurate ROI stats etc. However when you're serving 500K 
> pages per month it quickly grows unmanagable, so I've been rotating it 
> once a month and compressing and archiving the old logs.
> 
> This works ok but means that only the current months stats are easily 
> available to me for producing reports. What I'd like to do is log the 
> same kind of information to an SQL database which will (hopefully) be 
> more scalable and faster/easier when generating reports.
> 
> Has anyone done this and if so could they give me some tips? I was 
> thinking about putting a block of perl in an Autoload, but I'm not sure 
> whether this is the best approach.

Presumably we can extend Interchange's usertracking easily to log into
a SQL database. I'll look into that soon if you like. How do you
generate statistics from the usertracking information ? I'm sure that
other users will be interested in your experiences.

With regards

	Racke



-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team