Data queries to populate select drop downs

General question about how other people handle data fetching for drop downs in their apps.

Example:
A settings page for crud operations on customers with a paginated table of several customers. Limit set to 25 for each “page”.

In another page there is a drop down where you select from the customer table. Here you need all the customers, so there should be no limit on the query.

Many ways to handle this. Which one is preferred?

Community Page
Last updated: