What is the recommended best practice for Search Record List Limits from a table? Are 500,000 records or less acceptable?
Discussion posts and replies are publicly visible
What is your specific question? You cannot load 500k items!?! Maybe you elaborate on your use case so we can give better tips.
This question is geared towards a new implementation whereby the user requirement is to Search for about 50,000 wants 50,000 + unions to display in the record list. I read listing 100 records at a time can be configured to show page by page.
Not sure what is meant by "unions" but 50 000 records doesn't seem like much. I guess it also depends on how many fields and if you have large text fields in that table you want to search on.
You can pretty much define the limit that you want with the pageSize parameter of the grid. Personally, I've rarely seen more than 100 set as a page size.
Thank you for your response.