01. Problem

A travel search engine for a major hotel bookings aggregator company in the UK. Complete system redesign from a database-oriented processing based on a cluster of dozens SQL Server machines that was no scaling horizontally any longer due to architecture limitations. Most of the queries are read only (99%), about 200 million queries daily.

The main issue was caused by reaching the scalability limits – no further options to scale vertically with very limited horizontal scaling – adding a new SQL Server machine was increasing infrastructure cost by 2% and system throughput by only 0.1%.

Technical limitations started to become a serious business scaling issue – adding more clients and more hotel data became cost inefficient.

02. Solution

We studied the detailed system usage scenarios and statistics with the client and decided to extract the availability search into a separate cache layer based on in-memory data grid (IMDG) platform. This new solution holds in memory a complete set of data required to return a hotel availability information. We also implemented a custom, fast data loading mechanism to populate the memory grid from database as well as a message queue pipeline supporting incremental intraday data updates.

03. Results

Significant reduction of persistent database usage (SQL Server) and infrastructure cost down by 80%. Almost linear horizontal scalability of the search engine which is now based on in-memory processing with efficiency around 70%.

New business opportunities to scale the platform. After the first years of our solution in use the system was able to handle 50% greater traffic (over 300 million queries daily) with significant reduction of response times by 60%. More than 95% of queries are now served below a second.

The most surprising was the immediate commercial effect of the new implementation – revenue from the existing customers grew as they were now able to query the platform more frequently generating higher volumes.

 

Building a new application or extending your development team?

🚀 We're here to assist you in accelerating and scaling your business. Send us your inquiry, and we'll schedule a free estimation call.

Estimate your project

Consult your project

Submit the form to discuss your project and our software development, team augmentation and consultancy services. Our clients are located in the US, the UK, and Western Europe.

or call us: +1 415 340 8020 (US) or +44 20 3322 8684 (UK)

NULL

What happens next?

  1. Initial Request
    When you submit your request, we will immediately confirm it and analyze your initial questions and project scope.
  2. Discovery Call
    We schedule a call at a convenient time to discuss your project requirements and goals, and answer any questions you may have.
  3. Expert Meeting
    This meeting focuses on detailed project analysis, strategy development, and technology selection.
  4. Proposal
    Based on the insights gained from our discussions, we will prepare a commercial proposal that includes the scope of work, timeline, and cost estimates.
  5. Contract
    The final step is to sign a contract that defines the terms of our relationship and the framework for successful project delivery.
Arkadiusz Drysch | CTO

Testimonials

They have a very good company culture of their own, which gives them a real edge compared to other providers.

CEO

Leading UK system integrator

They're very skilled technically and are also able to see the bigger picture.

Managing Partner

Scalable SaaS for healthcare IoT built on Salesforce platform

They've been consistently able to deliver work on time and within budget.

CTO

High performance SaaS for financial insitutions

We are seriously impressed by the quality and broader picture of anything they do for us.

CEO

Gold trading platform