Delete All Records and Import or Import-Update; what are the pros and cons other than time?
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
2. Server Performs script to GO TO LAYOUT, SHOW ALL, IMPORT-UPDATE
Any & all feedback is appreciated. Thank you all in advance