Exceeded 5000 item limit in SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-2303357%22%20slang%3D%22en-US%22%3EExceeded%205000%20item%20limit%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2303357%22%20slang%3D%22en-US%22%3E%3CP%3EScenario%3A%20We%20exceeded%20the%205000%20items%20limit%20in%20SharePoint%20in%20the%20threshold%20list.%3CBR%20%2F%3ESolution%3A%20we%20add%20indexes%20to%20existing%20columns%20(Title).%20But%20I%20don't%20know%20the%20limitation%3C%2FP%3E%3COL%3E%3CLI%3EHow%20many%20items%20can%20be%20acquired%20when%20an%20index%20is%20set%20for%20a%20column%20with%20API%20filter%3F%3CBR%20%2F%3Elet%20items%20%3D%20await%20sp.web.lists.getById(this.listId).items.filter(Title%20eq%20'%24%7Btitle%7D').top(%3F)%20****%20%5B%3F%5D%20is%20the%20number%20of%20items%3CBR%20%2F%3E....%3C%2FLI%3E%3CLI%3EHow%20many%20items%20can%20be%20indexed%3F%20For%20example%2C%20we%20have%20a%20list%20with%2020000%20items.%20It's%20ok%20if%20we%20index%20all%20items.%20But%20I%20wonder%20if%20Indexing%20works%20when%20we%20have%203000000%20items%20on%20the%20list.%3CBR%20%2F%3E....%3C%2FLI%3E%3CLI%3EIf%20we%20have%203000000%20items%20(index%20column%20Title).%20Then%20i%20use%20api%3CBR%20%2F%3Esp.web.lists.getById(this.listId).items.filter(Title%20eq%20'%24%7Btitle%7D').top(5000).%20Will%20it%20work%20normally%3F%3CBR%20%2F%3E....%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Visitor

Scenario: We exceeded the 5000 items limit in SharePoint in the threshold list.
Solution: we add indexes to existing columns (Title). But I don't know the limitation

  1. How many items can be acquired when an index is set for a column with API filter?
    let items = await sp.web.lists.getById(this.listId).items.filter(Title eq '${title}').top(?) **** [?] is the number of items
    ....
  2. How many items can be indexed? For example, we have a list with 20000 items. It's ok if we index all items. But I wonder if Indexing works when we have 3000000 items on the list.
    ....
  3. If we have 3000000 items (index column Title). Then i use api
    sp.web.lists.getById(this.listId).items.filter(Title eq '${title}').top(5000). Will it work normally?
    ....
0 Replies