Stories

Performance · measured · The Last SQL Bender

A report query reading 190 times less data, with one rule

A report query filtered the date column through a function, so SQL Server read the whole table every time. Quentra proposed the fast form of the query; once the rule was enabled, reads dropped from 42,409 pages to 223.

Production Is Live, the Boards Aren't

The boards on five production lines fall behind the floor on a busy shift. The screens aren't at fault; a single query that converts dates is.

One Report, a Hundred Requests, One Run

On a month-end morning a hundred people want the same report, and every request recomputes it from scratch. Quentra Cache produces the answer once.

Support Without Seeing the Data

When the hospital system goes down, the support engineer has to connect to the live database. Quentra masks sensitive data at query time.

One Query, Every Register

A routine update pushes every barcode scan to 5 seconds. On the registers routed through Quentra the same query takes 0.1 seconds, 50 times faster.