SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to split the database used for a specific SharePoint list.

The reason is that the list has become too large with 1500+ items & now its affecting the performance.

Is it possible to split the DB from backend to make the list lighter?

I am using WSS 3.0

share|improve this question
up vote 2 down vote accepted


As far as i know sharepoint support database for site collection and not for specific list.

A better way to manage large lists in SharePoint site is to keep them inside folders. So you can decide to keep folder based on date or any other parameter and move the list items over there.

Another way is to make sure that you have views that gets you less number of list items and not all the items.

Following links might help

Hope this helps.


share|improve this answer

If you are having performance problems with a list containing 1500 items then I would suggest that you might have deeper issues than a need to manage the views/folders etc. Even in WSS 3.0 you should not notice a performance issue until around 2000 items.

You might want to look at what the list is used for, how it is being queried, what views are set up on it, what workflows are actively being used, any customisations (event receivers etc.)

There are many reasons NOT to use folders, for one thing they are not the best way to navigate an information structure as they are one dimensional. Meta-data is a much better way to organize your data.

Having said that if you purely want to reduce your item count you could use a combination of both to very good effect. The metadata gives you findability and the folders will reduce your item count.

There is no 'silver bullet' for performance issues on large lists. You need to to effectively diagnose the root cause of your problem first.

share|improve this answer

Your Answer


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.