We’re all about delivering seamless user experiences in our real-time database — and naturally, that’s something we wanted to extend to our Cloud Portal UI. Here’s what we did to accelerate its performance.

SingleStore Blog offers insights, tutorials, and updates on SingleStore, a distributed SQL database used for real-time analytics and data warehousing. Covering topics such as database architecture, performance tuning, and SQL queries, SingleStore Blog provides resources for developers and database administrators. Developers can learn about building scalable and high-performance applications with SingleStore by following their blog.

SingleStore

The SingleStore Portal UI project involved optimizing GraphQL queries, splitting the getInitialData query, fixing slowness in the 'Create Workspace' form, creating a custom hook to replace useQuery, making infrastructure changes, analyzing and lazy loading the bundle, setting up a React vendor chunk, treeshaking Lodash, and tracking load time via Mixpanel.

The Faster Portal Project: A Detailed Overview

splitting-the-get-initial-data-query Splitting the getInitialData query

fixing-slowness-in-our-create-workspace-form Fixing slowness in our ‘Create Workspace’ form

creating-a-custom-hook-to-replace-the-use-query-hook-in-apollo-client Creating a custom hook to replace the useQuery hook in Apollo Client

looking-for-infrastructure-changes Looking for infrastructure changes

analyzing-the-bundle Analyzing the bundle

react-vendor-chunk-setup React vendor chunk setup

the-magic-of-wildcard-imports The magic of wildcard imports!