C # UWP Windows 10

It is necessary to display a list of several tens of thousands of records in a grouped form. Now it is implemented as in the MSDN example through the CollectionViewSource which is the data source for the ListView . It works very well, but the problem is that you first need to load these records into memory from SQLite , which in itself takes a very long time. I found examples of how to implement ISupportIncrementalLoading , which would completely solve my problem, but it does not work with grouping.

What are the options for solving this problem?

  • I already asked you in my opinion - how do you imagine a grouped sheet with virtualization? Virtualization is suitable for linear lists, because you just need to take the offset from the current position. With grouping it turns out nonsense - there may be an entry that needs to be added to the sector that has already been viewed, but no one will see it. Do grouping at the model level and do not reinvent Frankenstein. - Monk
  • @Monk I understand your point of view, but in the model I also add new entries to the groups, and the UI displays them on the CollectionChanged event. The same can be with a grouped list, I would even come up with the option of increment not by records, but by groups. There are no more than 20 entries in one group, but in general there may be tens of thousands of entries, keeping it all in memory is clearly not an option ... - SYL
  • I did not encounter a task in this form, I would try to stick one foliage into another. At the top level - with virutalization, groups, at the bottom - without it, since there are up to 20 elements in total. - Monk
  • @Monk And this is already an interesting idea, thanks, I will try - SYL

0