Skip to main content
denisek0001
denisek0001
May 17, 2023
Question

Search Record List Limits

  • May 17, 2023
  • 4 replies
  • 0 views

What is the recommended best practice for Search Record List Limits from a table? Are 500,000 records or less acceptable?

4 replies

stefanhelzle0001
stefanhelzle0001
May 17, 2023

What is your specific question? You cannot load 500k items!?! Maybe you elaborate on your use case so we can give better tips.

denisek0001
denisek0001Author
May 17, 2023

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.

mathieud0001
mathieud0001
May 17, 2023

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.

Terms & ConditionsAccessibility statement