Launched: Performance Improvements

In the past couple of months, we have done several optimizations to improve the loading speed of Holistics:

  • Snowflake connection optimization:
    • Implement a connection pool for Snowflake to avoid connection initialization overhead in every Snowflake query
    • Result: Avoid 1 second of connection initialization overhead in every Snowflake query
  • Heavy job optimization:
    • Reduce unnecessary processing of Job data to accelerate Job initialization process, especially for large jobs. Example of large jobs: Jobs that run visualization on lots of Data Models;
    • Result: About 4x faster in Job initialization time
  • Dashboard performance optimization:
    • Enhancements have been made to the Permission Checking procedure, which improves Holistics’ resources fetching speed;
    • Result: About 4x faster in fetching Holistics’s resources
  • Dataset/Report Editor performance optimization:
    • Improve the loading speed of the data model fields list via lazy rendering/virtual scrolling;
    • Optimize the initial load of the Exploration/Report Editor
    • Result: Exploration/Report Editor now loads almost instantly and will never hang on the initial load

In the next few months, you may notice some performance updates from our team. Hope that our enhancement will bring you a better experience with Holistics :blush:


This post is for announcement purpose only. If you have any questions or want to know more about our performance improvements, feel free to drop us a message at [email protected].