A bus and coach operator in Europe
Client is a bus and coach operator in a European country.
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.
Multiple simultaneous page request to the server
Data processing happened on page in
Served web page. Each page was of 12.7 MB
Resulting in a crashed page
Process of Work
| Finding Customer Base | Data Analysis | Adaption of Technology | Integrating Mobile First Approach | |||||
| Gather Analytics Data | Locating Customer Demographics | Design 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.
MySQL Database
Query the database
for required data
Database returns the
requested data
Multiple simultaneous page request to the server
Served web page. Each page is of couple of hundred KB
Resulting in fast loading of the page
Results
- When the refined site was launched, the home page loaded within 3 seconds
- Seamless booking experience which resulted in 40% increase in overall conversion ratio.
