Feeding Data into ListView from SQLite Database

Question

I have millions of records that need can be searched and then appear in a ListView. Currently, these items are stored in an SQLite internal database.

Does anyone have a recommendation on the best method to feed these items into a ListView and have people scroll through them? Speed is critical here.

I don't want to do a "SELECT *" off of the database and feed all of the items into memory.

Answer 1

See this great article about data virtualization in WPF on Code Project. It provides asynchronous virtualized collection classes that seem to fit your needs perfectly.