Monday, January 24, 2011

SharePoint 2010 - Content Query Web Part (CQWP) Slow Loading New Items?

We've recently implemented several Content Query Web Parts (CQWP) which I love. However, I noticed that new items weren't showing up so quickly. I did a couple of quick checks to make sure items weren't checked out or unapproved but to no avail.

Then, after some digging, I came across the following article from Michael Nemtsev: Why Content Query Web Part (CQWP) doesn’t return all results.

The workaround is a simple one:
set “UseCache” property to “false”.

Interesting note from the SharePoint Team:

Cite from SharePoint Team:

“You are only seeing your items in edit mode because the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. You can disable caching on your Web Part by setting the "UseCache" property to false”

Just a handy note in case anyone else has trouble with that very useful (but sometimes pesky) Content Query Web Part.

Monday, January 17, 2011

SharePoint 2010 Limits, Thresholds, and Boundaries

Here are some key SharePoint 2010 Boundaries and Limits


Content database size - 200 GB per content database

Site collection size - 100 GB per site collection

File Size - 2GB - The default maximum file size is 50 MB. This can be increased up to 2 GB, however a large volume of very large files can affect farm performance.

Documents - 30,000,000 per library

Major Versions - 400,000

Bulk Operations - 100 items per bulk operation

List view lookup threshold - 8 join operations per query

List view threshold - 5,000

List view threshold for auditors and administrators - 20,000 - This setting works with Allow Object Model Override.

Subsite - 2,000 per site view

Web Parts - 25 per wiki or Web part page

Users in a site collection - 2 million per site collection

Alerts - 1,000,000 per search application - This is the tested limit.

Keywords - 200 per site collection

Social tags, notes and ratings - 500,000,000 per social database

Blog Posts - 5000 per site