A client I have wants to archive all orders processed over the web as a backup, and then delete all the orders out at the end of the month.
At the moment I'm using "DELETE FROM orders" but recently became aware that the auto_increment gets reset back to 1 using this method.
I suppose I could loop through every entry to delete the orders but that seems like it could take some time depending on how many orders are sitting in the database.
Can anyone think of a good solution for retaining the auto increment and deleting everything out?
