Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

KB Application Template & list item limits

  Asked By: Megha    Date: Jun 30    Category: Sharepoint    Views: 1524

We want to use the Knowledge Base "fab 40" application template at our
organization, though I am concerned about the soft item limits in
lists. Will the KB perf really suffer when it gets to ~5000? We
don't really want to archive articles, as being a knowledge base we
want as much info available as possible.

I also noticed this KB doesn't seem to be made to work well with
folders, thus making it hard to organize that way, although I suppose
I could move articles into subfolders manually, and they'd still be
searchable, hopefully still easy to browse.

Also, I do need to make customizations to the solution itself, then
deploy it to production, any tips to get me started there would be
very helpful (extract the .wsp? How to change the template that
creates the .aspx articles themselves - I want to add a custom
tree-view left nav?).



4 Answers Found

Answer #1    Answered By: Talia Johns     Answered On: Jun 30

Again, the official "limit" per list  is 2,000 items. BUT, Microsoft
has ended up saying that as long as you don't display more than 2,000
items in one VIEW, then you'll be okay. The real limit is somewhere
around a couple of million. So, FILTER THE VIEWS. (especially the
default ones)

Here's a really good whitepaper that goes into (very technical) detail
about large lists:

You also have a question about folders...
Folders aren't really the way to go. I believe the best practices is
to use metadata (list columns) to organize  the data instead.

Oh, and if you want to customize the solution  before deploying it,
you can first do your customizations, and then save the site as a
template, and then deploy THAT one to your environment.

Answer #2    Answered By: Tera Callahan     Answered On: Jun 30

More specifically, it's a guideline for best performance - 2000 items is
where performance starts to degrade, and it does so at a non-linear
rate. On folders - a folder is really just a view at it's core, so
there isn't really a significant performance difference between
organizing via indexed metadata columns and using folders.

Answer #3    Answered By: Mark Davis     Answered On: Jun 30

According to


performance is significantly better (comparing transactions per
second) using folders compared to indexed metadata (unfortunately).

Answer #4    Answered By: Delilah Mcpherson     Answered On: Jun 30

Interesting - I hadn't seen that comparison obviously. J It's counter
to the information I was given a while back by my Microsoft contacts,
will need to do a little follow-up I think...

Didn't find what you were looking for? Find more on KB Application Template & list item limits Or get search suggestion and latest updates.