There are many out-of-the-box tools in SharePoint to work with list data, and external lists are no exception. In fact, since SharePoint 2010, external lists share common implementation logic with native SharePoint lists, developers can easily support external data in their custom components. However, there is another side to the popularity of external lists. There are spikes in performance of the external system which can sometimes affect the functionality of external applications. In some other cases, you have a powerful data backend environment capable of supporting many requests from users allowing more users to access bigger data sets.
In this recipe, we'll take a look at how you can throttle the usage of the data coming from an external system.
The advantage of performing this configuration using a PowerShell is the ability to transfer your settings between environments as your application goes through its lifecycle.