more than 5000 records

Question

How can we display more than 5000 records in interface and search by custom picker? 
 
 Anyone having Idea?

Prasanta Paul · Answer

If you want to show the 5000 data in the interface, you can configure the page-nation with the help of looping. Like if your start index and batch size is not equal then you just go for the next. Like that you can configure. But what is the use

Prasanta Paul · Answer

I do not think so that will be not a good user experience. If you are filtering with "A" there is so many countries, if you are searching with "AME" may be there has only few countries or America only. Query the data and configure the filter like that. And why do you need to show much more data in an interface? I think you should not.

Prasanta Paul · Answer

I do not think so that will be not a good user experience. If you are filtering with "A" there is so many countries, if you are searching with "AME" may be there has only few countries or America only. Query the data and configure the filter like that. And why do you need to show much more data in an interface? I think you should not. 
 I think you got my point.

Mike Schmitt · Answer

Why are you using a Custom Picker for your search if you're showing a paging grid with your record list? 
 Just use a text field for your filter. When the user presses "search", apply the change to the existing query that's populating the paging grid - the results will be shown instantly. This should work for even a very large number of records, probably hundreds of thousands at least before it gets unusably slow. There's no reason whatsoever to be doing this using a Custom Picker.

Mike Schmitt · Answer

you should not be using a custom picker for a grid filtering field in the first place. see my earlier comment above in which I gave more detail.