jakob / jakob/Postico

Postico slow when dealing with text fields.

Open
#31 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

I have a one table which has no issue dealing with 1000 rows and another that does. The one that does have issues has a `text` field that can get quite large.

I also notice that when I hover over those `text` fields, `postico` tries to give me a preview of it, and I don't think that it's of a cut down version.

If I were to guess what the issue is, it might be that the contents of `text` field are involved somewhere in the creation of the result table and it's slowing things down. I could be wrong though and it could just be shortening 1000 potentially very large `text` fields that's the issue, but either way, I feel like it has something to do with `text` fields.

Contributor guide

No contributing guide indexed for this repository

Research direction

No file, test, or entry point is named. Start by reproducing the slowdown with a large text field, comparing result-table loading with text-field hover previews, and tracing which operation causes the delay. Done means the reported large-text case no longer causes the observed slowdown.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
database
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.