2 Replies Latest reply on Jun 19, 2014 11:51 PM by jacksrmd

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

    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