Skip to content

Case study · Transport and logistics

ACC Worldwide: a faster SQL Server system, noticed on day one

ACC Worldwide’s staff used one business system all day, every day, and it was slow. We worked on the SQL Server environment behind it. The speed-up was immediate, and staff noticed without being told to look.

Client
ACC Worldwide
Sector
Transport and logistics
Outcome
An immediate, noticeable speed increase on a system used every day
What we do
SQL Server performance work, a stronger database platform, and logging and monitoring for ACC’s own IT team
Technology
Microsoft SQL Server

The situation

The system worked. It was just slow, across hundreds of everyday tasks, and that adds up to a real cost in time and patience.

A slow system that still works is easy to put up with, and easy to keep putting off, because nothing is actually broken. ACC took the opposite view. It wanted the system quick, and a stronger platform underneath it so that future development wasn’t built on the same limits.

What we did

We worked on the SQL Server environment behind the application, in three directions at once.

Speed. We removed the delays users were hitting in their everyday work.

The platform. We strengthened the database platform itself, so there’s a sound base for whatever is built next.

Tools for ACC’s own team. The updated environment made logging and monitoring possible, so ACC’s IT team can see how the system is performing and spot problems before users report them.

What changed

Everyday tasks got faster straight away, and feedback from staff was positive. The system stopped being something people worked around.

ACC also came away with a platform it can build on and a view of its own system’s performance it didn’t have before.

In their words

From people we support

CDE took our tired old access database and transformed it into a system that is at the heart of our business. Everything is integrated – from a client’s first phone call to invoicing once the job is done.

Dearson Winyard International

Read the case study

 

The same project from the IT team’s side

Get in touch

What’s slow?

Tell us which part of the system people wait on, and roughly since when. We’ll come back with what we’d look at first and what it would cost.

Stopped altogether?

Call us

0114 249 1036