Case Study: PWS Distributors achieves 14x faster e-commerce performance and rapid ERP/SQL processing with DataCore Software

Online Kitchen Suppliers to the Trade, cook up faster performance and rapid response times from their ERP and SQL database systems

PWS Distributors, a leading UK supplier of kitchen components, was constrained by ERP/SQL performance: each product add triggered over 400 SQL commands and average product‑add delays exceeded 1400 ms, while invoicing and reporting ran overnight and staff lost productive time. To avoid re‑engineering their ERP, PWS engaged their IT partner Waterstons and adopted DataCore SANsymphony software‑defined storage (with Micron P420 PCI‑e flash) for optimization.

Waterstons installed SANsymphony in a dual‑node Dell T620 environment with PCI‑e flash, synchronous mirroring and adaptive caching, dramatically cutting I/O latency and boosting throughput. The result: e‑commerce add delays improved more than 14×, nightly invoicing fell from 2 hours to 20 minutes, best‑seller reporting dropped from 30 minutes to 10 seconds, an aggregated query went from >24 hours to 1 hour, and Customer Services gained over 2% active‑day time—enabling live system changes and additional online sales.

PWS Distributors

Andrew Buckingham

IT Manager