Khan / Khan/live-editor

Improve performance of SQL environment for basic operations (reduce freezes)

Open
#515 3 comments 0 reactions 0 assignees View on GitHub
bug sql
Dominant language
JavaScript
Stars
776
Forks
180
PR merge metrics
No merged PRs in 30d

Description

When using the SQL environment for even basic commands, there can be slight UI freezes. I've replicated this myself and also gotten reports via users (who may be experiencing more major freezes).

We don't do any of the SQL execution in a worker thread, so that would be one approach. We could also profile to see where the slowdown is coming from.

Contributor guide

No contributing guide indexed for this repository

Research direction

No file, test, or specific entry point is named. Start by profiling basic SQL commands and tracing the SQL execution path to identify the source of UI freezes; done means basic SQL operations no longer noticeably freeze the interface.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, sql
Domain
frontend, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.