SharePoint
Feedback by UserVoice

Aymeric de Montpellier

My feedback

  1. 1,419 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    157 comments  ·  Sites and Collaboration » Document Libraries  ·  Flag idea as inappropriate…  ·  Admin →

    We are continuing to make our large list experiences better, please keep the feedback coming.

    Spring 2018 update:
    - We now support being able to manually add indexes to lists of any size (increased from lists up to 20,000 items previously).
    - Starting with the February release of the Office 365 Excel client, you will be able to export your full list instead of getting cut off part of the way through.

    What we are working on now:
    - Predictive indexing will start to work for lists larger than 20,000 items so your views will automatically cause the right indexes to be added to your lists.

    In our backlog:
    - Being able to index/sort/filter by lookup column types (like person, lookup or managed metadata columns) without being throttled.
    - Making sure that our REST APIs support querying in ways that will guarantee that the call will not be throttled.

    For…

    Aymeric de Montpellier commented  · 

    The last admin's answer is good, providing more info, and the new coming changes will improve the experience with Sharepoint. Thank you for your work !

    Still not perfect, but at least you propose new features to make a difference, and it's a good start :-)

    Aymeric de Montpellier supported this idea  · 
    Aymeric de Montpellier commented  · 

    Hi,

    At least the threshold should not be activated based on the first argument of the WHERE clause....

    For example: I got a list with the columns `Data`, `Week` and `Year`. I have 1,000 items recorded each week.
    I need all data from Week 1 to Week 3 (for reporting purpose). If I do my WHERE clause with « `Year` = 2015 AND Week >= 1 AND Week <= 3 » then I'll get an error, even if the final result will return less than 5,000 items. And I can't do « Week >= 1 AND Week <= 3 AND Year = 2015 » because it will return an error as well. And again if I do « Week <= 3 AND Week >= 1 AND Year = 2015 » because it will look at Week 1, 2 and 3 for all the years recorded.

    Moreover, when we find that a list is too big (> 5,000 items), we cannot index the columns because it throws the threshold error.... We can only do it during the special time set up by IT. In my company, the servers are in the USA and I'm in France, so I have to index my columns at 1 am because of the threshold, during the special time!

    Also the Lookup columns limitation as well as the Workflow limitation are very boring.

    I'm pretty sure you can create something safe for the database, and not painful for users.

    Thanks

Feedback and Knowledge Base