jakob / jakob/Postico

Poor performance when a table has many indexes

Open
#329 0 comments 1 reaction 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.