i'm coding a soap connection interface for my magento2.1 to add and delete articles. When I try to delete all articles from my magento it takes a very long time. From one article to the next one it takes between 7 and 9 seconds.
What is the reason?
During this process htop says that 2 threads of mysql running between 80 and 90%. The rest of my 10 cpu cores are idle. My server (i7 3,3ghz, 24gb ram, ssd) has enough free capacity. I use Apache 2.4.18, php7-fpm, mysql 5.7.17.
What can I do to speed it up?
Thank you in advance
Regards
Ps. if it is interesting, this are 2 sequent soap requests of my program.
---[HTTP request - http://domain.com/soap/default?services=catalogProductRepositoryV1]---
Accept: application/soap+xml, multipart/relatedAuthorization: Bearer vke7g35av6583r11w1gd66uinminj029Content-Type: application/soap+xml; charset=utf-8;action="catalogProductRepositoryV1DeleteById"
User-Agent: JAX-WS RI 2.2.10 svn-revision#919b322c92f13ad085a933e8dd6dd35d4947364b
<?xml version='1.0' encoding='UTF-8'?><S:Envelope xmlns:S="http://www.w3.org/2003/05/soap-envelope"><S:Body><ns3:catalogProductRepositoryV1DeleteByIdRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="http://domain.com/soap/default?services=catalogProductRepositoryV1"><sku>64003855</sku></ns3:catalogProductRepositoryV1DeleteByIdRequest></S:Body></S:Envelope>--------------------
---[HTTP response - http://domain.com/soap/default?services=catalogProductRepositoryV1 - 200]---
null: HTTP/1.1 200 OKCache-Control: no-store, no-cache, must-revalidateConnection: Keep-Alive
Content-Length: 367
Content-Type: application/soap+xml; charset=utf-8
Date: Thu, 08 Jun 2017 19:24:28 GMTExpires: Thu, 19 Nov 1981 08:52:00 GMTKeep-Alive: timeout=5, max=41
Pragma: no-cacheServer: Apache/2.4.18 (Ubuntu)
Set-Cookie: PHPSESSID=4ulndcmooc5bsvclbagg5aqaf5; expires=Thu, 08-Jun-2017 20:24:29 GMT; Max-Age=3600; path=/; domain=domain.com; HttpOnly
<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope" xmlns:ns1="http://domain.com/soap/default?services=catalogProductRepositoryV1"><env:Body><ns1:catalogProductRepositoryV1DeleteByIdResponse><result>true</result></ns1:catalogProductRepositoryV1DeleteByIdResponse></env:Body></env:Envelope>
--------------------
---[HTTP request - http://domain.com/soap/default?services=catalogProductRepositoryV1]---
Accept: application/soap+xml, multipart/relatedAuthorization: Bearer vke7g35av6583r11w1gd66uinminj029Content-Type: application/soap+xml; charset=utf-8;action="catalogProductRepositoryV1DeleteById"
User-Agent: JAX-WS RI 2.2.10 svn-revision#919b322c92f13ad085a933e8dd6dd35d4947364b
<?xml version='1.0' encoding='UTF-8'?><S:Envelope xmlns:S="http://www.w3.org/2003/05/soap-envelope"><S:Body><ns3:catalogProductRepositoryV1DeleteByIdRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="http://domain.com/soap/default?services=catalogProductRepositoryV1"><sku>64003765</sku></ns3:catalogProductRepositoryV1DeleteByIdRequest></S:Body></S:Envelope>--------------------
---[HTTP response - http://domain.com/soap/default?services=catalogProductRepositoryV1 - 200]---
null: HTTP/1.1 200 OKCache-Control: no-store, no-cache, must-revalidateConnection: Keep-Alive
Content-Length: 367
Content-Type: application/soap+xml; charset=utf-8
Date: Thu, 08 Jun 2017 19:24:36 GMTExpires: Thu, 19 Nov 1981 08:52:00 GMTKeep-Alive: timeout=5, max=40
Pragma: no-cacheServer: Apache/2.4.18 (Ubuntu)
Set-Cookie: PHPSESSID=4usku5fb80rtb1s56l41q6b057; expires=Thu, 08-Jun-2017 20:24:36 GMT; Max-Age=3600; path=/; domain=domain.com; HttpOnly
<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope" xmlns:ns1="http://domain.com/soap/default?services=catalogProductRepositoryV1"><env:Body><ns1:catalogProductRepositoryV1DeleteByIdResponse><result>true</result></ns1:catalogProductRepositoryV1DeleteByIdResponse></env:Body></env:Envelope>
--------------------
