CODEWITHSUNDEEP
c#wpfperformancesqlitelistview
Kirk Ouimet
Kirk Ouimet

Reputation: 28404

Feeding Data into ListView from SQLite Database

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.

Upvotes: 1

Views: 1433

Answers (1)

Julien Lebosquain
Julien Lebosquain

Reputation: 41253

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.

Upvotes: 2

Related Questions