Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a sharepoint list which has grown above the maximum recommended size of 2000 items.

I need to delete the list. If I delete it through the browser, will there be any impact on the farm? Will it work ok?

Or do I need to go through using a powershell script and delete individually?

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

I believe it depends upon which SharePoint version you are using. Your question tells me that you might be using SharePoint 2007, since you emphasise on the 2000 items limit. This limit in the list is just for retrieving the items in a single view, but you can have millions of items as long as you don't display more than 2000 items in a single view.

You can view the msdn article for the entire limits in SharePoint 2007- http://technet.microsoft.com/en-us/library/cc287790.aspx

Deleting a whole list with just 4000 items should not have any impact. You should be able to do that through browser with a minimum delay. Deleting the list items individually through Powershell is not advised as it could impact your farm depending on the method and code you are implementing in Powershell.

I would also recommend to duplicate the site in a test environment to make sure that nothing is affected in your site when the whole list is deleted. Please also find other articles recommending similar situations - How may document libraries are recommended for a site?

share|improve this answer
    
Thanks, yep 2007 SP1. This is a large farm with a heavy load. I wanted to know if it would impact performance by using the browser to delete the list, instead of using PowerShell to delete item by item. –  Russell Jan 27 '12 at 10:42
    
There'll be zero impact doing it via the browser. Infact, you'll incur more stress on the farm doing it via the powershell, probably. Deleting the list via the browser is done as a batch process in the database. –  James Love Jan 27 '12 at 11:24
    
Thanks @james it had no impact as you said :) –  Russell Jan 30 '12 at 21:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.