Poor performance when a table has many indexes
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
When a table has many indexes (50 or more), Postico takes a very long time to display the table structure view. A beach ball is shown.
This is because of a performance problem with auto layout. (Auto Layout performance has improved significantly over the years, but it seems I'm running into a bad edge case).
Unfortunately this issue will take some time to fix, because rewriting the view code not to use auto layout is complicated.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start from the table structure view and investigate the Auto Layout path described in the issue. Reproduce the delay with a table containing 50 or more indexes, then confirm the structure view displays without a beach ball after the performance work.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- desktop, performance
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100