If you are using Oracle, I suggest truncating the table which would be much faster.
On Nov 12, 2007 8: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 > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
