AnsweredAssumed Answered

Delete All Records and Import or Import-Update; what are the pros and cons other than time?

Question asked by jacksrmd on Jun 19, 2014
Latest reply on Jun 19, 2014 by jacksrmd

Title

Delete All Records and Import or Import-Update; what are the pros and cons other than time?

Your post

     I have a daily download, M-F, of 69,000+ records (83 fields)

     Which procedure should I have the server to perform after hours so that the FileMaker solution is ready in the morning with the latest and greatest info + the server performs the script in the least amount of time?

     1.  Server Performs script to GO TO LAYOUT, SHOW ALL , DELETE FOUND RECORDS

     OR

     2.  Server Performs script to GO TO LAYOUT, SHOW ALL, IMPORT-UPDATE

      

     Any & all feedback is appreciated.  Thank you all in advance

Outcomes