On Nov 12, 2007, at 8:45 PM, schlub wrote: > We have a client with over a million rows in the stats table > (1,348,417 to be exact) that have brought the reports down to a crawl > (if they work at all). > > I tried to delete entries via the FarCry admin but it ended up timing > out and corrupting the database (fortunately it recovered after a bit > of site downtime). Is it safe to manually purge the stats table via > SQL? Are there any other tables or processes that I also need to do?
I've had sites where I've left FarCry stats on and neglected to maintain them for long periods of time. In these cases it is safe to manually run a SQL statement to purge the data. Usually what I do is clean them in short spurts (like 15 or 30 days at a time... depends on the speed and resources of the SQL server). So basically I run a SQL statement that says delete from stats where the datetimecreated field is older than 'manual date/time'. As for the other tables, I never touch them (they've never had enough records for me to worry about). To be honest, the only stats table I care about in FarCry is are the site search stats. I wish there was a way to only activate them while leaving the other stats disabled. Regards, -- Jeff Coughlin Web Application Developer http://jeffcoughlin.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
