If I read the SP list items for every 5mins using exe, will SharePoint give throttling error?

%3CLINGO-SUB%20id%3D%22lingo-sub-870203%22%20slang%3D%22en-US%22%3EIf%20I%20read%20the%20SP%20list%20items%20for%20every%205mins%20using%20exe%2C%20will%20SharePoint%20give%20throttling%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThere%20is%20a%20need%20that%20I%20need%20to%20scan%20the%20SP%20list%20items%20from%20multiple%20lists%20for%20every%205%20to%2010mins%20to%20find%20discrepancies%20in%20the%20list.%20Right%20now%20number%20of%20list%20items%20are%20not%20even%20200.%20But%20in%20future%20it%20will%20grow%20more.%20My%20question%20here%20is%2C%20if%20we%20run%20the%20exe%26nbsp%3B%20(console%20app)%20will%20SharePoint%20give%20throttling%20exception%3F%26nbsp%3B%20What%20is%20the%20idle%20frequency%20to%20get%20all%20list%20items%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870203%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871662%22%20slang%3D%22en-US%22%3ERe%3A%20If%20I%20read%20the%20SP%20list%20items%20for%20every%205mins%20using%20exe%2C%20will%20SharePoint%20give%20throttling%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F94568%22%20target%3D%22_blank%22%3E%40Mihir%20Yelamanchili%3C%2FA%3E%26nbsp%3BI%20am%20not%20sure%20what%20is%20your%20business%20requirement%20but%205-10%20mins%20is%20too%20much%2C%20if%20you%20have%20200%20records%20it%20will%20be%20fine%2C%20but%20let's%20say%20it%20has%20increased%20to%205000%2C%20based%20on%20what%20you%20do%20after%20getting%20all%20items%20can%20also%20take%205-10%20items.%20You%20will%20probably%20not%20hit%20throttle%20limit%20or%20issues%20till%20you%20are%20less%20than%205000%20but%20more%20than%205000%20can%20be%20issue%20as%20it%20might%20cause%20SQL%20queries%20to%20lock%20the%20database%20which%20generally%20happens%20if%20you%20cross%205000.%20You%20probably%20know%20that%20views%20with%205000%20items%20have%20problems%20so%20I%20am%20expecting%20same%20can%20happen%20for%20your%20app%20as%20well%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fsupport%2Flists-and-libraries%2Fitems-exceeds-list-view-threshold%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fsupport%2Flists-and-libraries%2Fitems-exceeds-list-view-threshold%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871862%22%20slang%3D%22en-US%22%3ERe%3A%20If%20I%20read%20the%20SP%20list%20items%20for%20every%205mins%20using%20exe%2C%20will%20SharePoint%20give%20throttling%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410289%22%20target%3D%22_blank%22%3E%40SinhaKislay%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20throttling%20error%20will%20come%20after%205K%20with%20coding%20solutions.%20But%20I%20am%20not%20even%20talking%20about%20that.%20Some%20times%20Microsoft%20will%20show%20error%20on%20the%20page%20for%20throttling%20because%20of%20heavy%20traffic.%20I%20am%20talking%20about%20that%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873920%22%20slang%3D%22en-US%22%3ERe%3A%20If%20I%20read%20the%20SP%20list%20items%20for%20every%205mins%20using%20exe%2C%20will%20SharePoint%20give%20throttling%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F94568%22%20target%3D%22_blank%22%3E%40Mihir%20Yelamanchili%3C%2FA%3E%26nbsp%3BSince%20you%20are%20using%20a%20exe%20and%20I%20believe%20you%20will%20be%20making%20coding%20calls%20the%20page%20throttling%20will%20not%20impact%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

There is a need that I need to scan the SP list items from multiple lists for every 5 to 10mins to find discrepancies in the list. Right now number of list items are not even 200. But in future it will grow more. My question here is, if we run the exe  (console app) will SharePoint give throttling exception?  What is the idle frequency to get all list items?

3 Replies
Highlighted

@Mihir Yelamanchili I am not sure what is your business requirement but 5-10 mins is too much, if you have 200 records it will be fine, but let's say it has increased to 5000, based on what you do after getting all items can also take 5-10 items. You will probably not hit throttle limit or issues till you are less than 5000 but more than 5000 can be issue as it might cause SQL queries to lock the database which generally happens if you cross 5000. You probably know that views with 5000 items have problems so I am expecting same can happen for your app as well

https://docs.microsoft.com/en-us/sharepoint/support/lists-and-libraries/items-exceeds-list-view-thre...

Highlighted

@SinhaKislay 

 

I know throttling error will come after 5K with coding solutions. But I am not even talking about that. Some times Microsoft will show error on the page for throttling because of heavy traffic. I am talking about that

Highlighted

@Mihir Yelamanchili Since you are using a exe and I believe you will be making coding calls the page throttling will not impact