How to reduce the load on the SQL server?

Question

SQL

Hello.

Tell me how to change the work of sql server in my situation. There is a site on WordPress. There is a Python script that parses the content and adds the data to one of the site tables. Select, update, insert, delete queries.

The problem is that when the Python script is running, the site is slow. Requests optimized as soon as could. I used indexes wherever needed, didn't use count, added fields to reduce the number of queries, hashed strings, etc.

Do I understand correctly that the next step is to just move the database to a separate machine in the cloud so that the Python script works with it, and let WordPress work with a copy of this database and make mainly select queries?

Answer 1

Run the script during the least load on the site, for example at night.