A bus and coach operator in Europe

Client is a bus and coach operator in a European country.

Service
Web development

Speciality
PHP (custom build)

Industry
Travel

About Project

This client had a newly built website, for one of its subsidiaries, which kept crashing after it went live. They approached us to improve the performance of the site. When we jumped in, we observed that the home page was taking about 45 seconds to load before it finally crashed.

We had to understand every nook and cranny of the website, understand the underlying data structure and relationships, figure out the root cause, come up with a solution, implement and launch it within a week.

Codeft Logo
problem image

Multiple simultaneous page request to the server

problem image

Data processing happened on page in

problem image

Served web page. Each page was of 12.7 MB

problem image

Resulting in a crashed page

Codeft Logo

Process of Work


Finding Customer BaseData AnalysisAdaption of TechnologyIntegrating Mobile First Approach
Gather Analytics DataLocating Customer DemographicsDesign Decision

Our Solution

During our system analysis, we discovered that the issue was due to the way the data was arranged. All the data was stored in CSV files on the server and whenever any page, not just home page, was accessed, those files were read and converted into a number of arrays which were then stored in the webpage. Based on how all this data was linked, the final size of web page ended up at 12.7 MB. This worked just fine during their development phase because the number of parallel requests to the server was minimal. However, once the website went live, because of the huge number of users, the server couldn't take the load and crashed.

process of solution image

MySQL Database

Query the database
for required data

Database returns the
requested data

process of solution image

Multiple simultaneous page request to the server

process of solution image

Served web page. Each page is of couple of hundred KB

process of solution image

Resulting in fast loading of the page

Codeft Logo

Results

  1. When the refined site was launched, the home page loaded within 3 seconds
  2. Seamless booking experience which resulted in 40% increase in overall conversion ratio.
Codeft Logo