[Interest] how do I load massive table views instantly?

David M. Cotter dave at kjams.com
Fri Jun 5 18:23:37 CEST 2020

>>> What table view are you talking about, specifically?
>> QTableView with QSortFilterProxyModel
> What is the model _behind_ QSFPM?
i'm trying to understand your question. i'm not sure what you mean, cuz i'm not the SQLite dev
what i know is that each song has a couple dozen bits of data (name, artist, album, several file paths, rating, duration etc etc)
besides that, what are you asking?

> Does that model support async loading?
okay, how would i answer this question?
i guess ask the developer of the DB

> Note that QSFPM may still need to load the entire source model (didn't check its source code) if you ask it to filter or sort. For 200k elements, I'd expect the source model itself to support filtering and sorting, without the need of a proxy in front of it.
would this allow me to have multiple playlists, each with it's own view into the model, with different columns showing in different orders, different sets of songs, possibly with a filter?
and switch between them instantly? ie: not have to take time to switch, to show the first page of data?
and allow the scroll thumb to instantly be correctly sized, such that the user can take the thumb and drag it to the bottom, and instantly see the last page? no waiting?

thanks, i'm a newbie here in terms of SQLite and how it all works, and i'm speaking on behalf of the dev, so i only know JUST enough to ask maybe dumb questions but not enough to answer perhaps some smart ones...



More information about the Interest mailing list