What is the best way to tie the sparsed database to the site?

Question

Netcat CMS

I have little experience, so I'm asking how best to do it.
There is a site on cms Netcat. Everything is on a dedicated server with other sites.
It is necessary to fasten the sparsed database for 30k+ positions to the site, the database must be updated at least once a day.
It is necessary to make a certain selection on a specific page.
How, in a good way, to organize all this and not break anything?
Those. it will be normal if you run the parsing script using the crown and upload it to the general database of the site. It's just that if something goes wrong (the script doesn't work correctly, the timeout hangs itself..etc.) you'll have to take action.

Answer 1

It is necessary to break the process of loading third-party data into two stages. First, take the data to the database2 and if everything went well, then transfer it to the working database1. Or, after successful data loading, change the connection string, pointing to base2, etc. Then if something goes wrong, you will not switch base names at most.