1 Reply Latest reply on Sep 27, 2012 10:31 AM by gdurniak

    Fast Empty Table : badly needed

    Vincent_L

      I've already talked about it in my Speed, speed… post (refering to it as the Truncate function), but after having waisted more than 7 hours this past two days emptying 3 tables (that got bloated due to a bad data input), I felt the need to insist on that.

       

      We badly need a Empty table script step that will destroy all its content immediately (like MySQL Truncate), at least for table that are not involved in cascading deletes.

      It could fall back to delete all if cascading delets exists if FMI inc can make it fast with cascading deletes.

       

      But please, please, please create that script step ASAP. Deleteing all content of a table is needed in many many automation case, where you need to import data, or work wiith temporary tables. If such a Empty table script step I'd save at least 2 hours per day of script processing time.

       

      Thanks

        • 1. Re: Fast Empty Table : badly needed
          gdurniak

          Or a "Save as Clone" that would operate on only one table

           

          This would also help in cases where the Record ID's get scrambled, and records can't be deleted  e.g. phantom records

           

          greg

           

          > We badly need a Empty table script step that will destroy all its content immediately (like MySQL Truncate)