On Thu, 21 Oct 2004 11:53:27 +0100 Jamie Neil <suppressed> 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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.