We use SQL and it supports truncate too... I discovered that after I sat there for 5 mins deleting 5000 rows at a time and wondering why it was taking so long ;) The remaining 1.3 million rows only took a few seconds to delete :)
If anyone cares the SQL command is: TRUNCATE TABLE stats (where stats is the table name you are purging) On Nov 14, 3:45 am, "Beth Bowden" <[EMAIL PROTECTED]> wrote: > If you are using Oracle, I suggest truncating the table which would be > much faster. > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
