Forum Discussion
How much time it takes to query 5 records out of 10 million records from SharePoint List/Library?
Hi, I have a requirement where we need to store more than 5 million records in a list and that will keep on growing. I will be using SharePoint REST APIs to query SharePoint list looking for 10 t...
Hi! It's really really not recommended to have that many record in one SharePoint list. But using Rest API query you can query 5000 items per call. So you need to loop it, so it's gonna take a while and probably throttle you...
https://learn.microsoft.com/en-us/microsoft-365/community/large-lists-large-libraries-in-sharepoint
https://learn.microsoft.com/en-us/microsoft-365/community/large-lists-large-libraries-in-sharepoint