Hello community,

I've been asking this in r/learprogramming, but I din't get an answer, so here might be a better place.

I'm trying to create a cueing system for videomapping / vjing. Basically one Cue consists of some strings, a few bools, and lots of values, let's say 10.000 wich are of type int and double. In a big a show we have up to 200 cues.

So I'm keeping them in a sqlite database. So I guess, it won't be a good Idea to fetch all the data and get it into a big List. So I'm asking how can the data be efficiently presented to the user.

How do I display and manipulate the values? Would I need to know how much memory one cue consumes, in order to know the maximum auf data i can load. How do i calculate that?

Assuming that I have a big Cuestack to be played back, would I just load a few rows (again: how to calculate how many?), and with the progression of the playback, the next rows are being loaded? Which way would you got to display that data?

All that I can think of at the moment: put it in a List, and fill a ListCollectionView with it, and display with a DataGrid. That would eat a lot of performance, wouldn't it? At the end, the user should be able to scroll through the whole cuestack, or is there a way to kick the rows out of memory, when they are not visible? To be correct for playing back the DataGrid would not need to contain all the collumns of a cue, but just a few significant ones.

Which leads to the problem of displaying all the data of one row, in order for the user to edit that in a separate Window / Tab, but I'm gonna kick that can down the street until I understand the basics.

Greetings and thanks in advance.