Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Max # of Sub-sites?

  Asked By: Urjita    Date: Jul 19    Category: Sharepoint    Views: 1234

I have a Team Site built that is basically a portal with lists of
Consultants grouped by specialty. Each consulting firm on the list
also needs access to a single Page that they will be able to
customize as needed.

The way that I have architected this is that the top site is a Team
Site and the consulting firm has its own sub-site (in order to
support different site access) based on the Publishing Template (in
order for the Site owner to approve content before it is available
for all portal users to see)

So far so good. Well, now I have been told that they want to roll
this out glabally. Which means that eventually the number of sub-
sites could be in the THOUSANDS.

I don't think that my design will scale to that level.

Are there any other ways to architect this that anyone can think of?

The main objective here is to provide each consulting firm with its
own page that only they can customize and to also have any changes
made to a page be approved before it is viewable by other users.



7 Answers Found

Answer #1    Answered By: Rosalinda Merrill     Answered On: Jul 19

I'm no architecture expert, but I'm pretty sure you don't want to
have just one site  collection in that case. You'd probably need to
have seperate site collections for each consulting  firm, so that you
don't have just one giant content  database.

There are drawbacks to having separate site collections, but I think
in this case, it would be worse to have just one big one.

Answer #2    Answered By: Yogendra Zarapkar     Answered On: Jul 19

Subsites follow similar rules to list items and folders - for best
performance you'll want to keep these under 2000. I second Laura's concerns
about having a single site  collection (and therefore a single  content

Answer #3    Answered By: Jerad Mercado     Answered On: Jul 19

Thirded. Aside from the performance drag of having one giant content  DB,
you have no real security isolation if they're all in the same site

Answer #4    Answered By: Riley Scott     Answered On: Jul 19

I agree with the concerns expressed about having all these child sites in one
content database. Hence they shouldn't be in one site  collection. But I
wouldn't make each one their own site collection either. See if you can't find
some other characteristic to group them on and make that the root of the site
collection, for example region. Then create each site as a child site under the
appropriate site collection. Otherwise you will have a high level  of security
administration required and you won't be able to share information between sites

Answer #5    Answered By: Adya Khavatekar     Answered On: Jul 19

A challenge in going this route is the difficulty in segmenting the
sites. A single  company can show up in numerous sub-categories
(geographical regions and specialties, sub-specialties).

If we went this route, I assume I can reference the other site
collection in the URL from another site  collection? Also, what about
authentication between site collections? It it seamless?

Answer #6    Answered By: Trupti Patil     Answered On: Jul 19

"You'd probably need to have seperate site  collections for each
consulting firm"

I would agree with you except that the site for that consulting  firm
only exists of a single  page. They will not be able to add any
additional pages.

Answer #7    Answered By: Marlena Noble     Answered On: Jul 19

I haven't followed this entire thread, so excuse me if this has been said.
Remember, all sites within a site  collection are constrained by a single
database (a site collection cannot span databases). So, if the data set is very
large, you'll have several content  DBs regardless. I have this problem often
with clients, and we generally find a way to organize sites into site
collections using divisions, regions, sales rep, security, etc (optimally,
you'll arrange them by business processes). There is probably not a 'silver
bullet', but don't let that stop you from trying!

Didn't find what you were looking for? Find more on Max # of Sub-sites? Or get search suggestion and latest updates.