Performance with large lists...

I have been looking around and playing with lists with over 2000 items in them. Although it is not hard limited to it, some (not all) systems with list over 2000 items do have performance issues. Here's a couple of links that are usefull:

• http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2545505&SiteID=1 (SQl and workflow issues)


• http://blogs.msdn.com/sharepoint/archive/2007/07/25/scaling-large-lists.aspx (white paper that gives a good comparision of different accessing strategies)


• http://blog.krichie.com/2007/02/14/can-you-really-have-more-than-2000-items-per-folder-in-sharepoint-now/ (performance)

I will play around with it a bit and see if I can find some solid evidence that SharePoint lists should not have more than 2000 items. If anyone has such proof, please send it to me.

Fadi