Case Study Deskcasestudydesk.com
Real Estate / PropTechSourced

Case Study: Real Estate Analytics made its data pipeline 50x faster with ClickHouse

Real Estate Analytics Case StudySourced & dated by Case Study Desk
Key facts · TL;DR
Company
Real Estate Analytics
Industry
Real Estate / PropTech
Challenge
MongoDB too slow for interactive analytics
Headline result
A pipeline operation dropped from about half an hour to under 30 seconds after moving off MongoDB

Key results

50x
Faster pipeline operation
about half an hour to under 30 seconds
10x
Faster queries
vs MongoDB

The challenge

Real Estate Analytics offers interactive, frequently updated real estate market analytics. Its architecture relied on MongoDB, where interactive queries took several seconds and a key pipeline operation ran about half an hour, which was unacceptable for a product marketed as interactive.

The solution

After evaluating ClickHouse at a Singapore ClickHouse meetup, the team migrated its data pipeline to ClickHouse.

ClickHouse saved us from quite a number of headaches.

SL
Yi Sam Lee
Lead, Real Estate Analytics

The results, in context

The company reported that queries which had taken several seconds in MongoDB ran about 10 times faster in ClickHouse, and that a pipeline operation which previously took roughly half an hour finished in under 30 seconds, a 50x improvement. Figures are quoted from the published story and dated.

Products used

ClickHouse ClickHouse