Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

app hangs when looking at details of a JSONB field #500

Open
ccurvey opened this issue Oct 6, 2024 · 2 comments
Open

app hangs when looking at details of a JSONB field #500

ccurvey opened this issue Oct 6, 2024 · 2 comments
Assignees
Milestone

Comments

@ccurvey
Copy link

ccurvey commented Oct 6, 2024

  1. Create table containing a JSONB field
  2. Populate the JSONB field
  3. In the query tool, run "select * from mytable"
  4. double-click on a cell for the JSONB column
  5. try scrolling to the right to see more of the data. App will hang

I'm not sure if it's related to large values in the JSONB field or not.

I'm running PgManage 1.1 on Ubuntu 24.04 (fully patched) using MATE for my desktop.

@eug3nix eug3nix self-assigned this Oct 7, 2024
@eug3nix
Copy link
Collaborator

eug3nix commented Oct 7, 2024

Hello. I have tried to reproduce this issue and can confirm that the app may be slow with large amounts of data in the cells. In my case app did not hanged completely but was very slow with data from this file : https://raw.githubusercontent.com/json-iterator/test-data/refs/heads/master/large-file.json
I don't think there is a quick solution to that though. I'll leave this ticket open, hopefully we can figure something out later.
Thanks!

@eug3nix
Copy link
Collaborator

eug3nix commented Oct 8, 2024

A possible solution for this would be to implement cell-level lazy-loading so we don't waste network traffic and memory until the data is requested by the user.

@eug3nix eug3nix added this to the 1.3 milestone Oct 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants