Customer

Fleet Management

Location

India

Segment

Transport

Solution

Data Architect

Customer Profile

The client is one of the premier service providers of Commercial Fleet Management Solutions in North America.

Objective

The client uses MySQL database for its critical business processes, which, however, was affected due to the changing business environment and prompted a switch to the more commonly used SQL server.

A direct swap resulted in poor performance characteristics at greater loads. The client wanted us to optimize its business performance.

BluePi’s Solution

With the underlying architecture and code base remaining the same, it was obvious the issue lay with the database. BluePi Consulting was tasked with determining the root-cause of the poorer performance and remediating it. While there could be a myriad of possible causes, we went about eliminating these in the order of likelihood.

However, none of these highlighted the cause. While checking the performance characteristics of queries, we did notice that one of the queries was taking a lot longer on SQL Server than on MySQL. The table being accessed in this query contained a large amount of data and the data fetch was taking much longer. This pointed to the optimization of the indexes – and the realization that the two DBMS treat clustered and un-clustered indexes very differently. (SQL Server doesn’t automatically optimize un-clustered indexes).

AWS Service used

MySQL, SQL Server, SQL Prfiler, AWS

Read

More Case studies

Helped a Leading DTH Company to Analyze Consumer Behaviour
Helped a Leading DTH Company to Analyze Consumer Behaviour

Company DTH Company Location India Segment DTH Solution Analytics How well do you know your...

ABP News- CMS Migration to Cloud
ABP News- CMS Migration to Cloud

Customer ABP News Location India Segment Media Solution Migration Customer Profile ABP News, a leading...

How BluePi Helped automate deployment for Repchecker AWS DevOps
How BluePi Helped automate deployment for Repchecker AWS DevOps

Customer Qmetrix Location USA Segment Hospitality Solution DevOps Customer Profile qMetrix provides customized, integrated logistics...

call to action

Invest in better
solutions today