Forum Discussion
SPO lists and the 5k view limit - what's your strategy?
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...
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?
I'll look into that. Some other questions I have:
- 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?
- 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.
