Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
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

 

Highlighted
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 - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html