aws / graph-explorer

React-based web application that enables users to visualize both property graph and RDF data and explore connections between data without having to write graph queries.
https://github.com/aws/graph-explorer
Apache License 2.0
317 stars 47 forks source link

[Project] Optimize database queries #358

Open kmcginnes opened 5 months ago

kmcginnes commented 5 months ago

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

Addresses

Consider

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