How to handle large lists in SharePoint?

In SharePoint, Large lists are handled by using a concept called Throttling .

Throttling refers the no of items that will be queried from the List. A Threshold Limit will be applied by Administrators.

If we do not apply threshold limit and if users issues a queries to retrieve the large data, it will effect your system.

SharePoint supports 30,000,000 items per list.

The default List threshold value is 5k items which is available in the Central Administration

CA -> Manage Web Applications -> Click on Web App -> Select General Settings -> Select Resource Throttling