I have a performance problem with Magento 2.1
In my shop, I have 90.000 products. I added these products to soap. When I did this it took round about 7 seconds for each article (product?) (Request>Response). In summary, it took a few days to init all products.
Now all the products are in the shop. All a few weeks I have to update some things on the articles (products). When I do this with soap again, it takes the same duration. When I do updates the shop is unusable. An example request and response are here: https://pastebin.com/aqnMJk98 https://pastebin.com/UAh0h8Zz
My server has a 12 core CPU, 24 GB RAM, and SSD. Its running Ubuntu 16.04 with Apache2 PHP7-fpm and MYSQL.
When I watch the update process I see that 5 cores with MySQL are at 100% PHP is working a little bit and the rest is idle. The ram is only a small amount used
iotop says that my SSD is bored.
I watched the database performance and saw that Magento fired in the adding process thousands of commands to the database. Is this OK?
When I update it with the Magento CSV import it is much faster.
What can I do to speed this Magento2 up? In this situation its impossible to work well with this shop.