Massive performance decrease on BLOB column at data page

suurjaak / SQLitely

SQLite database tool

https://suurjaak.github.io/SQLitely/

MIT License

7 stars 3 forks source link

Massive performance decrease on BLOB column at data page #4

Open psharper opened 1 week ago

psharper commented 1 week ago

Hi,

using SQLitely version 2.3, 10.07.2024 on default Kubuntu 24.04 as a Snap.

When there is a BLOB column in the table filled with small binary data ~80KiB per row ~15 rows and opening a new Data tab page, the app hangs about 25s. Interaction with the tab page is also nearly impossible.

This did not happen, if you create the tab page by executing a sql query, because there the BLOB col is cut off.

suurjaak commented 1 week ago

Confirmed: data grids in Linux start lagging when columns have very long values.

Will figure out a workaround for the problem.

Thank you for reporting this.