I have Db for ~5000 items and use LINQ queries to filter output for LongListSelector.
It is not so fast as expected, due to every KeyPress on filter TextBox triggers "search".
Is any recipe or "CookBook" how to do it properly?
Fast filter for LongListSelector
62 Views Asked by alex At
2
There are 2 best solutions below
0
Timothy Macharia
On
I have a better and a much easier suggestions drawing inspiration from ajax and angular js.
When the app gets loaded at first, call an async Task method that will populate your list from the database to a collection in your app which will be a global variable in this case.
Then when you want to search..,only search through the local collection in your app. I tried this one out and its lightning fast.
Related Questions in LINQ
- How to filter properties of derived classes in a DbContext with dynamic LINQ
- Query (or LINQ in Entity Framework) for getting user's rank
- How to return Inserted Updated Id in a Merge query
- Equivalent of LISTAGG in LINQ doesn't work
- Getting attribute from xml and printing it error
- Linq Grouping and workaround data entry errors in groups
- 'Unable to cast the type 'System.Guid' to type 'System.Object'. LINQ to Entities only supports casting EDM primitive or enumeration types.'
- linq issue accessing deep xml data
- OrderBy with lambda?
- Evaluating logical expressions recognized by ANTLR using the System.Linq.Expressions namespace
- Implementing List<T>, why wont it cast back to MyList after LINQ ? (Unable to cast object of type 'WhereListIterator`1)
- Linq GroupBy and Filter
- LINQ group by date and time
- How do I achieve client-side evaluation in LINQ?
- How do I create a Linq query that will return multiple complex properties in a sub property of a table?
Related Questions in WINDOWS-PHONE-8
- How did windows application "phone link" open the webpage automaticly can IT also open the files on our computer
- Possible to create an app on Windows Phone (WP) using Visual Studio 2022 or later
- Development of old window phone Apps using flutter
- OpenID Connect in c# for Windows Phone app
- How to generate refresh and access token for Windows phone app
- Exception in Json response when Submitting to webapi from WP8
- Passing Class Object to WCF Service c# wp8
- Identify Store App Type
- Why connectivity plugin network handler not working when navigation happens
- How to scroll listbox automatically when Scrollviewer present above it has finished scrolling
- Pixel by Pixel color conversion using WriteableBitmap
- Read stream from absolute uri
- error unhandled exception during loading desiger for the first time in visual studio 2012
- windows phone emulator not displayed , showing error 0x80131500
- How to get font file from windows phone
Related Questions in WINDOWS-PHONE-8.1
- Windows Phone StackPanel control alternative for Xamarin Forms?
- XamlParseException when using the XAML Designer
- Issues while publishing a Windows phone app in the Windows Store
- PublicClientApplication cctor doesn't work on windows phone 8.1 (System.NullReferenceException)
- How to extract String path from ApplicationData.Current.LocalFolder
- Get app purchase date for Windows Phone 8.1 and Windows 8.1 applications
- How to create thumbnail/snapshot from bing maps in c# for universal solution
- When I touch webview content and then somewhere outside after the app crashes
- Unable to load DLL 'sqlite3': in windows phone app.
- How to give dynamic width to gridview items (text block)?
- URI Scheme for Microsoft Equalizer app on Windows Phone 8.1
- Changing style based on trigger with Xamarin.Forms on WinPHone 8.1
- Why does Visual Studio create another *.appx inside a folder Dependecies
- HttpClient hangs for large request
- Windows Phone 8.1/10 App Developement
Related Questions in LONGLISTSELECTOR
- how to make a windows phone app with LongListSelecter shows images and texts
- how to make a windows phone app LongListSelecter with Image and strings
- LongListSelector Data Binding Issue
- c# update ObservableCollection in socket
- Long list selector windows phone child control event in DataTemplate
- LongListSelector set image visibility on selection change
- Correct implementation of IGrouping to be used inside longlistselector groupheader
- Fast filter for LongListSelector
- Windows Phone : Long List Multi Selector - Adding items in SelectedItems List manually from code. Checkbox not checked
- Need help filtering an AlphaKEyGroup
- Can't select the same item from listbox twice in a row - windows phone 8 C#
- LongListSelector C# - How to get SelectedItem as string from grouped data list - Windows Phone Silverlight 8.1
- LongListSelector content does not match parent
- How to binding friendlist as longlistselector in windows phone 8
- Windows 8.1 phone app ExtendedListView.GroupStyle not working
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Instead of filtering all the data. Try to filter the data into bunches, like top 200 or 300 at a time and when user scroll down the list keep on filtering remaining data. I hope this will help you.