As far as I'm concerned DeepMetrix needs to go back to the drawing board with LiveStats. I've got LiveStats 6 installed using MySQL on a dual processor 1.26 MHz PIII with 2 MB ram. I've done what I can to tune MySQL, throwing almost a GB of ram at it and it still constantly pegs both processors at 100% for 70-80% of the time. The databases that LiveStats creates are enormous, with indexes typically twice the size of the actual data. I found out that DeepMetrix has such a poor handle on the organization of the tables that it's virtually impossible to delete old data from the stats history. That is, if at the end of 2002, you wanted to delete stats from prior to the year 2002, you can't do it. You would have to literally delete the site and then reimport 2002's logs. Otherwise, the tables grow indefinitely. Oh, and when you delete a virtual site from LiveStats, it doesn't even drop the site's tables. I don't think these guys have a very good handle on db design. I suspect this is why MySQL is struggling to keep up with the stats for just 100 sites.
LiveStats 5 was _much_ less resource intensive, but we had problems with databases constantly getting corrupted. Check out Urchin @ http://www.urchin.com.; I've heard nothing but good things about it. For a service provider, it may get pricey, though. Jim ----- Original Message ----- From: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 6:54 AM Subject: OT: Server Stats/Analayze Program > I'm currently evaluating DeepMetrix's livestats6 vs. WebTrends pacakge. > Can anyone recommend or share his experience? > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
