Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimise query results #616

Open
artemmufazalov opened this issue Dec 21, 2023 · 3 comments
Open

Optimise query results #616

artemmufazalov opened this issue Dec 21, 2023 · 3 comments

Comments

@artemmufazalov
Copy link
Member

artemmufazalov commented Dec 21, 2023

Currently on very big datasets in results or with big request stats some use cases are very slow and could take up to 2-3 seconds 😱. Big stats are quite a common thing for requests with multi schema.

Use cases:

  1. Switching from History or Saved tab to Query tab if there are some results
  2. Switching to results from stats and vice versa

What could be done:

  1. Keep rendered elements on screen (for example with display: none), so they won't be calculated again. Applicable to result tables, stats, ast, explain plan and Fullscreen component
  2. Optimise data calculations and rendering

Migrating QueryEditor files to TS is essential for this issue: #619


Inspired by: #595 (comment)

@antonkovalenko
Copy link
Member

@Raubzeug please link this one to a ticket about migration

@Raubzeug
Copy link
Contributor

Raubzeug commented Oct 2, 2024

@antonkovalenko I've double checked the situation, and it still needs some improvements.
Huge tables are re-rendering every time we return to the tab with results (or switch to Fullscreen). Let's evaluate this issue as is.

@Raubzeug Raubzeug changed the title Optimise QueryEditor Optimise query results Oct 2, 2024
@antonkovalenko
Copy link
Member

antonkovalenko commented Oct 7, 2024

@Raubzeug please add a screencast and a new issue about json inspector #1388

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants