Home

Problem

We need to send lots of data to Magento via the web API, particularly for products and stock which have thousands of updates each day.

Some requests are also very slow, like updating an attribute that has hundreds or thousands of options, and this creates timeouts.

Magento produces deadlocks on various tables at any more than 1 concurrent request for product updates. The higher number of requests, the more deadlocks are created. This creates a lot of failed requests which must be retried continuously before the update is saved by Magento.