Feeds:
Posts
Comments

Posts Tagged ‘Performance’

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

Read Full Post »

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 [...]

Read Full Post »

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
/// [...]

Read Full Post »

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 [...]

Read Full Post »