search

hankinsoft / SQLPro

SQLPro bug & features tracking.
100 stars 26 forks source link

App Hangs when clicking on Data tab with a table with millions of rows #993

Open yood opened 1 week ago

yood commented 1 week ago

Describe the bug In SQLPro for SQLite, when tapping the Data tab while having a table with 3.1 million rows selected, the app hangs.

To Reproduce Steps to reproduce the behavior:

  1. Open database with Schema tab selected.
  2. Click on a table with 3.1 million rows
  3. Click the Data tab
  4. App hangs

Expected behavior The app to not hang and instead show a paginated view of the table.

OR it should behave like the query screen where it loads the query incrementally while the app is fully responsive. In the Query screen, it takes 32 seconds to load a select * from table_with_3_million_rows

Screenshots It just hangs until I force quit.

Environment details (please complete the following information):

Additional context Add any other context about the problem here.

hankinsoft commented 1 week ago

Any chance you could provide the sqlite file, or a sqlite file that reproduces the issue? It can also be emailed to me directly via kyle @ hankinsoft.com.

hankinsoft commented 6 days ago

Reproduced and am seeing what you are seeing. Working on some possible solutions - for now I would suggest trying to just use the query tab, until I can get that sorted.