On Nov 13, 12:45 pm, schlub <[EMAIL PROTECTED]> 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 would assume I need to purge stats, statsCountries, statsDays, > statsHours and statsSearch too
It is safe to truncate the primary stats table. Do not touch the other tables (statsCountries, statsDays, statsHours). We are planning on ripping out the entire web stats reporting section and making it an optional plugin as part of Fortress (4.1). In addition, the Verity service will be replaced with a plugin, that maintains its own independent statistics. Verity plugin is quite stable and used in a number of our production sites today: http://docs.farcrycms.org:8080/confluence/display/FCPLUG/FarCry+Verity -- geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
