You need to sign in to do that
Don't have an account?
dlucia21
What is the best practice for refreshing 50,000+ records?
We have a data file that contains over 50,000 records that we get from a partner. The file may grow with additions and it may shrink with records that have been deleted. They are advising us to delete and insert every night 50,000+ records.
The problem with that is the recycle bin gets overloaded with all the deleted records.
Is there a way to delete records permanently without them reaching the recycle bin?
Would it be better for them to assign a unique id to each record and perform and update and insert?
What should I do?
The problem with that is the recycle bin gets overloaded with all the deleted records.
Is there a way to delete records permanently without them reaching the recycle bin?
Would it be better for them to assign a unique id to each record and perform and update and insert?
What should I do?
Your partner should be reasonable and only send you changes and additions and deletions.
Cheers