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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
