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

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

Cube Dev Logo
技术
  • 应用基础设施与中间件 - 数据库管理和存储
  • 基础设施即服务 (IaaS) - 云数据库
适用行业
  • 建筑物
  • 半导体
适用功能
  • 产品研发
  • 质量保证
用例
  • 交通监控
  • 交通模拟
服务
  • 系统集成
  • 测试与认证
关于客户
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!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。