Multiple sql queries vs List of data

I have a RecylcerView to which I'm adding items, which could span from hundrends to thousands. These items also need to be sorted based the current fragment i.e. by title, artist, genre etc.

The question is, how should I manage the data, should perform the queries just before I add the item to the view or keep a list of the data objects containing all the information and then sort that when needed?

Is there a better solution? I'm concerned that the List of data objects could use too much memory. Is that the case?