taylorsharpe

Truncate table script step

Discussion created by taylorsharpe on Aug 6, 2016
Latest reply on Aug 8, 2016 by jormond

I went to the FMPUG users group meeting in Dallas on Friday and we were summarizing Devcon last month when Heather McCue brought up that fact that there is a new script step, Truncate Table, that is like SQL drop.  It immediately deletes all records in a table.  WOW!!!!!  Have I wanted that in the past.  Say I have an import table that I want to import data, then parse it out.  After parsing, the data is useless and needs deleted.  But oh my gosh FileMaker can be slow at deletes.  Some of my huge tables have taken days to delete millions of records.  Granted it is limited scope of when I want to delete an entire table, but this is so much faster than either waiting for deletes or other games such as cloning and reimporting other tables, etc.  Anyway, apparently I need to keep studying these new features so I can take and hopefully pass the new 15 certification.  But cool thing to learn about!  Thanks FileMaker!

 

Now to go implement it and make sure it works as I think it does. 

Outcomes