graph-explorer icon indicating copy to clipboard operation
graph-explorer copied to clipboard

Published 20 hours ago • verified publisher icon aws

[Project] Optimize database queries

Open kmcginnes opened this issue 9 months ago • 0 comments

We can trace many reliability and performance issues to sub-optimal database queries. Here, we attempt to tackle some of the most impactful database queries in the app.

Plan

The general approach is to reduce the complexity of the database queries we are performing. At the same time, we can defer performing some of the queries until the user interacts with the UI that requires that data.

Also, by using TanStack Query for the database queries we can regain caching of the queries. This will also provide good options for automatic and manual retries.

Related Issues

Tasks

  • #357
  • #304
  • #369
  • #370
  • #371
  • #372

Addresses

  • #263
  • #324
  • #240
  • #225
  • #301
  • #269
  • #401

Consider

These issues may be partially or completely solved by the effort in this issue.

  • #314
  • #184
  • #410

kmcginnes avatar May 08 '24 14:05 kmcginnes