Posted in Analytical, Technical, tagged MOSS 2007, Performance, SharePoint, WSS 3.0 on January 2, 2008 | Leave a Comment »
Item
Limit
Number of sites in a site collection
250,000
Number of subsites nested under a site
2000
Number of lists on a site
2000
Number of documents in a library
2,000,000
Number of documents in a folder
2000
Maximum document file size
2GB
Number of documents in an index 50M
50,000,000
Number of search scopes
1000
Number of user profiles
5,000,000
Posted in Analytical, tagged MOSS 2007, Performance, SharePoint, WSS 3.0 on January 2, 2008 | Leave a Comment »
The below is a rough calculation that may be used for estimates. The sample calculations below are based on migrating 100GB of existing documents with an average file size of 1MB and planning for five years of growth. The typical estimate should include having disk storage equal to one and a half times the total [...]
Posted in Technical, tagged ASP.NET, Performance, UI Design on December 26, 2007 | Leave a Comment »
For performance reasons, I prefer to disable ViewState in all ASP.NET controls unless I explicitly need to. This arises from my desire to keep web page HTML payload to 15KB for sub-second response times (a personal UI design goal).
/// <summary>
/// Class member used to disable ViewState at the DataGridItem level. This method must be
/// [...]
Posted in Technical, tagged Performance, SQL Server, T-SQL on December 26, 2007 | Leave a Comment »
I personally prefer to avoid cursor-based looping in T-SQL or PL/SQL because of the obvious performance gains. This blog post is for a friend who needed a quick way of looping through and building a string in T-SQL without using cursors.
– Function to concatenate records in a single variable using set-based processing
SET QUOTED_IDENTIFIER OFF [...]
