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.
Chat, ads and tracking load more JavaScript than your own shop code at the median. How to find, defer, replace and remove third-party scripts without losing features - and win back load time.
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.
WebGPU is active in all major browsers in 2026. Small language models now run directly in the browser - for private shop assistants, semantic search and text snippets, offline and without API costs. We sort out the chances, limits and hybrid approaches.
Cross-document view transitions are available in all major browsers and give classic shops app-like changes - framework-free. Learn to implement @view-transition, morphed product images and speculation rules.
Prerendering via the Speculation Rules API makes product and checkout pages appear near-instantly. Ray-Ban doubled its mobile conversion this way (web.dev).
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.