The process of building custom applications and tools that interact with Microsoft SharePoint, including SharePoint Online in Microsoft 365.
Hello @john john Pter
First, I recommend reviewing the AI-generated response on your post, as it already provides some helpful insights that align closely with what you observed.
In summary, Microsoft guidance recommends keeping the total number of synced items under approximately 300,000 for optimal performance. When a library grows beyond that threshold, as in your case with around 500,000 items, the OneDrive desktop application can begin to experience the types of sync issues you are seeing. This happens because the sync client needs to build and maintain a local index (and in many cases a two-way replica) of the library on each device, which becomes very resource-intensive in terms of CPU, memory, disk, and network usage.
In simpler terms, the issue is not with SharePoint itself, which can handle significantly larger libraries, but with the scalability of the desktop sync client when dealing with very large numbers of files.
As immediate steps, I would suggest enabling Files On-Demand (if not already in use) so that most files remain in the cloud and are only downloaded as needed. It is also advisable to reduce the sync scope by selecting only the specific folders users require instead of syncing the entire library.
For a longer-term solution, it would be beneficial to review your overall library structure and consider splitting the content into smaller, more manageable libraries, for example by department, project, or time period. Please consider this approach if it fits your environment since this might help ensure each sync scope stays within a range where the client can operate reliably.
As a note, Microsoft has started introducing improvements that support higher sync limits in certain scenarios, but a library of this size is still considered large, so applying selective sync and optimizing the structure remains important for a stable experience.
For more in-depth and targeted guidance based on your specific environment (such as tenant-level diagnostics or log analysis), you may need to open a support request with Microsoft Support. As this is a user-to-user forum, moderators like us do not have access to backend tools or internal diagnostics to investigate further.
Hope this information helps.
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.