Hello everyone,
I’m currently experiencing severe performance issues with my Shopware installations (Community Edition, Shopware 6.6.10.x) — both in dev and prod mode.
Initial Situation
I’m running two Shopware 6 shops (Docker, PHP 8.3, Nginx, MySQL/MariaDB, Redis, and Elasticsearch). Initially, the loading times were good (~100 milliseconds for the homepage). We’re using various plugins and have imported customer data (~400 customers) and orders (~600) from the old Shopware 5 shops. Performance issues have occurred in both installations.
Troubleshooting
Since I couldn’t pinpoint the issue in a copy of the production shop, I started a fresh Shopware installation (without plugins) and imported the data step by step. While adding products and categories and installing/activating plugins, I didn’t notice any performance problems.
The issues only began after importing the customer and order data.
- Memory usage and load times increased significantly — about 1.5 GB of RAM and 10 seconds of load time.
- Deleting all customers and orders does not improve performance.
The customer and order data were originally imported using the Shopware Migration Tool. I then exported the data via SQL and imported them into the new installation.
When loading any shop page, the request takes more than 5–15 seconds. According to the Symfony Profiler, most of the time is spent on the following components:
kernel.controllerContextResolverListenersales-channel-contextcart-rule-loader
Questions:
- Has anyone observed similar behavior after importing customer and order data?
- Are there any known causes or suggested solutions that might explain this behavior?
I appreciate any insights or experiences you can share!
