实例探究 > 使用 Cube 提高仪表板性能：Jobber 的成功故事

使用 Cube 提高仪表板性能：Jobber 的成功故事

技术

适用行业

适用功能

用例

服务

关于客户

Jobber 是一家为小型家庭服务企业提供商业管理软件的领先提供商。他们支持 50 多个行业，并为超过 47 个国家的超过 1500 万个家庭提供服务。他们的平台帮助服务专业人员保持井然有序、与客户联系并发展业务。

挑战

随着业务规模扩大并积累了十年的数据，Jobber 团队的仪表板性能逐渐变慢。他们尝试了缓存、查询优化和数据库调整，但意识到还有更多工作要做。

解决方案

Jobber 开始使用灵活的分析平台 Cube 来提高仪表板性能。他们利用了 Cube 的两级缓存系统和外部预聚合功能。他们将 Cube 拆分为 API 服务器和计划刷新服务器，并进行相应配置。他们还将 Cube 纳入其 CI 管道并执行性能测试以优化资源使用。

运营影响

The implementation of Cube in Jobber's system has significantly improved the performance of their dashboards. The two-level caching system of Cube has eliminated the need for Jobber to maintain their own optimization code, simplifying their operations. The external pre-aggregations capability of Cube has also been beneficial, as it allows Jobber to build pre-aggregations inline within their read-only source database. Furthermore, Jobber's active engagement with Cube's open-source community has not only accelerated their own development but also provided valuable insights to the Cube Dev team on actual use cases in production environments. The successful deployment of Cube has led Jobber to explore other areas where Cube can reduce engineering costs while delivering great features for their customers.

数量效益

Jobber supports over 50 industries and has serviced over 15 million households in more than 47 countries.
More than 100,000 service professionals use Jobber's platform.
Jobber's architecture involves a single PostgreSQL database backend, a read-only replica of the database to populate the rollup pre-aggregations database.

Case Study missing?

Start adding your own!

Add New Record