structure view performance degrades with large column count
- Dominant language
- Python
- Stars
- 486
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
while the content view for large tables performs better than any other postgres app, the structure view performance degrades noticeably for tables with more than 40 columns. Adding additional columns takes longer for each new column. To reproduce just create a new table and hit the `+ Column` button a bunch of times. After `column50` it takes 3 seconds on my macbook air for the new column to appear, after `column70` the app starts to beachball for a while.
Contributor guide
No contributing guide indexed for this repository
Research direction
Reproduce the slowdown in the structure view by creating a table and repeatedly using the `+ Column` button. Observe the time to add columns around column50 and column70, then trace the structure-view column-add path. Done means adding columns no longer degrades noticeably or beachballs with large column counts.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres
- Domain
- database, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100