Reading the Slow Query Log: When the Database Is the Brake
Slow shops rarely have a visible problem, they have an expensive one. How the slow query log, measured execution plans and matching indexes reveal where the compute time actually goes.
Insights on e-commerce, web development and digital solutions
Slow shops rarely have a visible problem, they have an expensive one. How the slow query log, measured execution plans and matching indexes reveal where the compute time actually goes.
Peak season is in the calendar, yet hardly anyone knows their shop's capacity ceiling. This guide shows how to derive a load profile from last year's data, run a staged load test against a production-like copy, define target value, warning threshold and emergency stop, and build an emergency plan with rehearsed relief valves - including an operating calendar from July to January.
In PHP 8.5 OPcache is built in. This guide shows which OPcache values save response time in a shop, when JIT tracing helps on CPU-bound routes and hurts on I/O-bound ones - including migration from PHP 8.4.
Data residency is not data sovereignty: why the US CLOUD Act reaches EU-hosted data, what the EU Cloud Sovereignty Framework with eight objectives and five SEAL levels requires, and how to run your shop's customer, order and payment data sovereignly.
Ransomware and human error hit every shop. This guide shows how tested 3-2-1 backups, defined RTO/RPO targets and a documented recovery plan form a resilient contingency plan - and how disaster recovery differs from monitoring.
Late order mails, a stale search index, an outdated sitemap: how to move the Shopware message queue into production with CLI workers, separate queues and alerting.
The storefront HTTP cache now works with login and a filled cart. How the sw-cache-hash works, what changes in invalidation and how to prepare extensions safely.
With 8.0.46, support for MySQL 8.0 ends. Why the EOL database under your shop is first an audit problem - and how the move to 8.4 LTS works.
Maintenance windows cost revenue. How blue-green and canary deployments with cache warmup and clean session handling take new versions live without your shop ever going offline.
You decide which optional data processing to allow.
Our anonymous reach measurement runs without cookies and without IP storage — we do not ask for consent for it because none is legally required.
Strictly required: language preference, core site functions and storing your cookie choice. Without these the site does not work.
Stores your preferences in your browser's local storage (e.g. light/dark appearance, accessibility options). Improves comfort but is not strictly required.
Records your interactions (clicks, scrolling, inputs) pseudonymously so we can spot usability issues. Form field inputs are masked automatically before storage; your IP address is not saved with the recording. Served from our own domain, no external tool. Opt-in, revocable any time.
Allows measurement of advertising campaigns (internal UTM attribution, e.g. whether a visit came from an ad). No external advertising cookies.