Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
New Member
Posts: 1
Registered: ‎07-03-2013

HELP - Deleting 500,000 records?

[ Edited ]

Two questions:


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.


Thanks Terry


Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: HELP - Deleting 500,000 records?

Big "Depends".....

   Depends on:

         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.

RJ Ledger - +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..." - blog: