Doug, I like the TRUNCATE TABLE command, but I'm thinking this cannot be used within a transaction.
4D's documentation website is down, otherwise I would have confirmed this first. Steve -----Original Message----- From: 4D_Tech [mailto:[email protected]] On Behalf Of Douglas von Roeder via 4D_Tech Sent: Tuesday, April 04, 2017 1:04 PM To: 4D iNug Technical <[email protected]> Cc: Douglas von Roeder <[email protected]> Subject: Re: delete or truncate Chuck: I'd go with truncate. It's a command whose function is to clear all the tablespace allocated to records in a given table along with the associated indexes. Delete selection is used to delete one or more records, ensuring that indexes and relational integrity constraints are enforced for each record deleted. I've used truncate a couple of times and it's *very* fast. In a V13 system, Truncate table deleted 10 GB of tablespace//11MM records in 10 seconds (MacBook Pro with SSD). ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
