Modern SharePoint list-Very slow for the end user

Harry N Nomikos 1,246 Reputation points
2021-09-08T02:33:29.68+00:00

Hi Team

I've recently migrated our change teams database to SharePoint list online (modern view) which is an updated SharePoint version from what was used before.

The end users have been mentioning that it's very slow and is laggy when trying to go into a certain view or when they try and create/filter/update an entry.

The form it itself has over 300 list items and includes:

  • JSON formula to have form set up in sections
  • JSON formula for headers and footers
  • Conditional formatting to flag certain conditions
  • Has been linked to another SharePoint site
  • Has over 88 columns to fill in
  • 50 people have access to it with updates occurring at any given time
  • 8 custom views to choose from

Is there a way where we can optimise the speed so it's not so slow in responding.

Cheers,
Harry

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,992 questions
0 comments No comments
{count} votes

Accepted answer
  1. Elsie Lu_MSFT 9,781 Reputation points
    2021-09-08T07:08:53.743+00:00

    Hi @Harry N Nomikos ,

    I would suggest you don't do so many custom settings in the same list. According to my investigation, there are no clear restrictions in the SPO list, however more custom settings will inevitably affect the performance in the list.

    For list performance, common steps are like below, have a try:

    1.Add indexes on columns.
    2.Edit the view and apply filters. Make sure only a portion of items will get diplayed under the current view.

    Reference:
    Manage large lists and libraries

    Similar posts:
    SharePoint Online Performance extremely slow
    SharePoint Online List performance slow on new item


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful