Forum Discussion
Searching for Items in SharePoint Lists with over 5000 Items
I've tested this, and was disappointed to learn that if you run a query within a view, results show below the search box, but the list view results are limited to those within the list.
If I created a list with names of fruits and vegetables, and created a view for those beginning with 'A' and searched for 'Banana' it would not appear on the list when I completed the search, but would appear below the search box as I was typing.
If we can have 30,000,000 items, but we can only search for 5,000 at a time, what is the point of having so many items?!
Should I stop using SharePoint lists for storing data and only use them for document libraries?
Without my AWA, I feel helpless.
Even Document libraries with larger than 5000 documents have same issues. I have been struggling with this issue for quite some time, Microsoft support says this is a limitation from browsers and they can't handle loading so many records, but that is no excuse for not being able to fetch a single entry from a list when you search for it. I mean when i search for items I expect the search runs in the database not in a cached list within my browser.
hopefully Microsoft have a solution coming out for this or a search feature replacement.