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

[yood]

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):

• Device: MacBook Pro Apple M1 Max
• OS: macOS 14.5 (23F79)
• SQLPro app Version: SQLPro for SQLite Version 2024.30 (Build 4374)
• Installation source: App Store?
• Target database server: SQLite

Additional context Add any other context about the problem here.

[hankinsoft]

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]

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.