How to correctly add data to the database?

Question

Database

Good day to all!
The database has a reference table (let's say id + object description) of 20k lines, which needs to be updated daily (adding up to 10 records) based on a new xml file.
Is it correct to upload a new file to a temporary table and add new records to the main one when updating?
Or is it better when uploading a file (using python, for example) to immediately detect new records and add them to the main one?
DB Access, Oracle, MySQL

Answer 1

And how will you define new records using python? Are they marked in the file somehow? Or will you make a select from the database for each entry to check whether it is there or not?
If they are marked, then it is easier in python to select only new ones and load them into the database. If unchecked, then twenty thousand validation selects will work much slower than one large insert into a temporary table and then comparison using the database itself.