SPO lists and the 5k view limit - what's your strategy?

%3CLINGO-SUB%20id%3D%22lingo-sub-823538%22%20slang%3D%22en-US%22%3ESPO%20lists%20and%20the%205k%20view%20limit%20-%20what's%20your%20strategy%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823538%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20currently%20have%20about%2010%20SPO%20lists%20and%20they%20all%20are%20over%20the%205k%20view%20limit.%26nbsp%3B%20Even%20though%20we%20use%20views%20to%20show%20less%20than%205k%2C%20with%20no%20sorting%20and%20filtering%20on%20index%20created%20dates%2C%20we%20are%20still%20having%20a%20ton%20of%20issues%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ethrottle%20messages%3C%2FLI%3E%3CLI%3Equick%20edit%20no%20longer%20works%3C%2FLI%3E%3CLI%3Etrying%20to%20filter%20from%20the%20view%20itself%20just%20shows%20the%20spinning%20wheel%3C%2FLI%3E%3CLI%3Eexporting%20to%20excel%20doesn't%20work%20on%20occasion%20as%20the%20list%20is%20too%20large%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20how%20is%20everyone%20using%20SPO%20lists%20once%20you%20reach%20the%20limit.%26nbsp%3B%20Are%20you%20using%20it%20only%20as%20a%20data%20entry%20tool%20and%20then%20moving%20all%20data%20to%20another%20platform%20after%20it's%20entered.%26nbsp%3B%20Another%20wrinkle%20is%20I'm%20using%20Power%20BI%20to%20report%20on%20all%20these%20lists.%26nbsp%3B%20I%20also%20need%20to%20be%20able%20to%20access%20the%20list%20to%20make%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20columns%20are%20very%20wide%2C%20about%2040%20columns%20on%20some%20of%20them%2C%20could%20that%20be%20the%20big%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELove%20to%20hear%20your%20insights.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-823538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823603%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20lists%20and%20the%205k%20view%20limit%20-%20what's%20your%20strategy%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823603%22%20slang%3D%22en-US%22%3EThe%20more%20columns%20you%20have%20in%20a%20list%2C%20the%20worse%20is%20going%20to%20be%20the%20performance%20and%20behavior%20when%20the%20list%20becames%20heavy...I%20think%20most%20of%20your%20problems%20are%20due%20to%20that%20amount%20of%20columns%20in%20the%20list...have%20you%20reviewed%20the%20lists%20indexes%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824660%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20lists%20and%20the%205k%20view%20limit%20-%20what's%20your%20strategy%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824660%22%20slang%3D%22en-US%22%3E%3CP%3EI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20look%20into%20that.%26nbsp%3B%20Some%20other%20questions%20I%20have%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3E%26nbsp%3BEven%20though%20the%20lists%20are%20separate%2C%20are%20they%20still%20somewhat%20connected%3F%26nbsp%3B%20Meaning%2C%20if%20one%20list%20is%20being%20heavily%20used%20by%20multiple%20people%2C%20will%20that%20impact%20other%20lists%3F%3C%2FLI%3E%3CLI%3EIf%20my%20Power%20BI%20reports%20are%20all%20updating%20and%20pulling%20in%20new%20data%20from%20SPO%20at%20the%20same%20time%2C%20will%20that%20cause%20a%20performance%20issue%3F%26nbsp%3B%20I'm%20cutting%20back%20on%20when%20and%20the%20number%20of%20times%20PBI%20updates%20to%20see%20if%20that%20will%20help.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

We currently have about 10 SPO lists and they all are over the 5k view limit.  Even though we use views to show less than 5k, with no sorting and filtering on index created dates, we are still having a ton of issues:

  • throttle messages
  • quick edit no longer works
  • trying to filter from the view itself just shows the spinning wheel
  • exporting to excel doesn't work on occasion as the list is too large

 

So how is everyone using SPO lists once you reach the limit.  Are you using it only as a data entry tool and then moving all data to another platform after it's entered.  Another wrinkle is I'm using Power BI to report on all these lists.  I also need to be able to access the list to make changes.

 

My columns are very wide, about 40 columns on some of them, could that be the big issue?

 

Love to hear your insights.

 

Thank you

2 Replies
Highlighted
The more columns you have in a list, the worse is going to be the performance and behavior when the list becames heavy...I think most of your problems are due to that amount of columns in the list...have you reviewed the lists indexes?
Highlighted

I@Juan Carlos González Martín 

 

I'll look into that.  Some other questions I have:

 

  1.  Even though the lists are separate, are they still somewhat connected?  Meaning, if one list is being heavily used by multiple people, will that impact other lists?
  2. If my Power BI reports are all updating and pulling in new data from SPO at the same time, will that cause a performance issue?  I'm cutting back on when and the number of times PBI updates to see if that will help.