07-03-2013 03:39 AM - edited 07-03-2013 03:41 AM
1. Is there a faster way to delete 500,000 records than Tools/Maintenance/Purge?
2. Once I begin a delete, if I cancel 1/2 way, will those records already deleted stay deleted?
I started a purge over 9 hours ago and so far only 60,000 +/- deleted.
07-03-2013 04:51 AM
A - does the data need to synch?
B - Do you know enough SQL to be able to construct (and run) the SQL commands in the proper order
It's possible to execute a series of SQL commands to do what you want to do. The important thing is to delete the "child" (lowest level" records first.
No matter how you do it - it's not going to be instantaneous.
Give a shout - we are in the office.