Tip #103: First visit of authenticated user might cause performance issue Featured

Rate this item
(2 votes)

"When an authenticated user, whom has never visited a site collection, first visits a site there are a number of tables within the Content database which must be updated". This process might be very expensive and affect the overal performance of the SQL Server for the large farm. It is recommeded to prepopulate the user's table using SPWeb.EnsureUser() API.

More details about this tip can be found in the following article http://todd-carter.com/post/2011/09/20/Introduce-Users-Into-the-UserInfo-Table.aspx


Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.