tag:blogger.com,1999:blog-5655646.post8849054380836134025..comments2009-01-23T08:39:27.363-05:00Oskarhttp://www.blogger.com/profile/02957780889508741710noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5655646.post-889901006420913072009-01-23T08:39:00.000-05:002009-01-23T08:39:00.000-05:00I agree that the 2000 items limit is a myth which can be ignored - <B>IF</B> - you use the lists correctly<BR/><BR/>You can checkout my blog series about SharePoint List Performance at <A HREF="http://blog.dynatrace.com/category/net/sharepoint-net" REL="nofollow">dynaTrace Blog</A>.<BR/>This series looks into the SharePoint Object Model to highlight what is actually going on between the SharePoint Servers and the Content Database<BR/><BR/>Hope it helps to understand SharePoint Internals better to build better apps on top of itAndreas Grabnerhttp://blog.dynatrace.comnoreply@blogger.comtag:blogger.com,1999:blog-5655646.post-75898084880917326022008-10-24T18:09:00.000-05:002008-10-24T18:09:00.000-05:00This was a typo...<BR/><BR/>-jbAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5655646.post-8142372417314316082008-09-25T14:35:00.000-05:002008-09-25T14:35:00.000-05:00As I said, the 2000 limit was never a hard limit, just a best practices guideline. It all depends on how many items you return in the page, how many security principals are attached (if you break inheritance and use item-level permissions), whether there are indexed fields, etc, etc. I have personally tested lists with 5000+ items (without folder hierarchy) and you do start seeing gradual increases in response time. Deletes especially get slow past 2-3000 items.<BR/>Also the one comprehensive test I have seen of this show a steep drop off in responsiveness at around 4000 items. <BR/><BR/>My point is only this: the GUIDELINE appears to have been shifted to 3000 for the first time - that's all.Oskarhttp://www.blogger.com/profile/02957780889508741710noreply@blogger.comtag:blogger.com,1999:blog-5655646.post-46367506058679515982008-09-25T03:38:00.000-05:002008-09-25T03:38:00.000-05:00The theorhetical limit solution works with views as well as folders so if there are over 2000 items in a list (with no folders) as long as the view of the list does not show all those items it should be OK. I have recently tested this by having 2500 items in a list viewing them in groups of 100 which was perfectly fine.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5655646.post-59156157011937770712008-09-24T13:57:00.000-05:002008-09-24T13:57:00.000-05:00hmmm have you tried it ?Anonymousnoreply@blogger.com