Success story

Travel search engine handling 300 million queries daily

After the first years the system was able to handle 50% greater traffic (over 300 million queries daily)

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

Related Case Studies

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

The developed software product was built from scratch with solid quality. We have had a long-term engagement with Stratoflow for nearly 10 years. We look at them as partners, rather than contractors. I'm impressed by their team culture and cross-team support.

Nathan Pesin

CTO, Legerity Financials

Stratoflow was a great partner, challenging as well as supporting our customer projects for the best outcome. They have a great pool of talent within the business - all very capability technologists, as well as being business-savvy and suitable for consultancy engagements.

Chris Goodall

Managing Consultant, CG Consultancy (UK) Limited

The bespoke metal exchange platform works great, it is easily accessible and richly functional. Stratoflow managed deadlines capably, meticulously documented their progress, and delivered a complex project at an affordable cost.

Bartlomiej Knichnicki

Vice Chairman, Supervisory Board

We are very pleased with our partnership with Stratoflow and, as we continue to grow, we expect to increase the numbers of developers that work with us on our projects. They have proven to be very skilled and flexible. They're extremely reliable, and they have a very good company culture of their own, which gives them a real edge compared to other providers that serve more as production shops rather than thought partners and creative problem solvers.

Andrew Kennedy

Founder & Managing Director, Tier 2 Consulting

Stratoflow successfully customized the system according to the specific functionalities and without bugs reported. The team was commended for their adaptability in the work process and for their responsiveness.

Joshua Blavins

Tech PM, Digital Agency

The features implemented have received overwhelmingly positive feedback from end-users. Stratoflow has an incredible technical expertise and a high degree of flexibility when it comes to changing project requirements.

Adam Hill

Chief Technology Officer, Legerity

They have impressively good knowledge of AI issues. Very responsive to any amendments and findings. Very good communication. We received a finished project which could be implemented into production shortly after testing.

CO-Founder & CTO

Circular Fashion Company

They provided superb service with seamless communication and a highly professional, technical approach. The team displays impressive technical expertise and are willing to share information and engage in constructive feedback.

Filip Stachnik

Operations Manager, Otwarte Klatki (part of Anima International)

They're very skilled technically and are also able to see the bigger picture. Stratoflow can actually think about solutions, not just the technical task at hand, which they've been assigned.

Arnd Jan Prause

Chief Operating Officer, musQueteer

Stratoflow delivered the website successfully within the timeframe and budget. They assured that the output met the set requirements. Overall, the team's performance was excellent and recommended for their exceptional technical business expertise. They've been able to deliver all of their work on time and within budget, which has been very impressive.

Lars Andersen

Founder & CEO, My Nametags

Travel sector rebound after the pandemic is complete. We have fantastic global coverage of travel data distribution due to mutual agreements and data exchange between aggregators. Competition for the best price of limited resources degradates margins.

How to win? Provide personalized experience and build your own products in the front-office. The missing bits: a traveller golden record collecting past activities and a AI/ML recommendation technology.

Michał Głomba

CEO at Stratoflow