Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How "lightweight" are SPWebs?

  Asked By: Tanesha    Date: Jan 05    Category: Sharepoint    Views: 1106

Often in front of a group of developers, I like to characterize an SPWeb as
extremely lightweight but don't have any quantitative metrics to back this


1. Has anyone tried to measure how many database rows are needed to
represent an SPWeb created with the WSS Blank web site definition? .or
anything similar?

2. How much SQL database storage is typically required to store a site
collection containing 10K, 20K, 30K, 40K or 50K Blank web sites?



1 Answer Found

Answer #1    Answered By: Josie Barron     Answered On: Jan 05

I used a SQL Server database  comparison utility called dbMaestro to compare
a content database before and after the creation of a child web  site in a
new site  collection (with a single root web site) .and the results are .drum

1 Webs record

23 Features records

1 AllLists records

16 AllDocs records

----- -------------------

41 content database records

Interesting but no surprising. Other details:

Child web site inherited security and even though it was created  with the
Blank web site definition, the number of AllDocs ghosted files and Features
records dominated the total number of database records needed  to represent a
SharePoint web site.

Didn't find what you were looking for? Find more on How "lightweight" are SPWebs? Or get search suggestion and latest updates.