Re: how capable is sharepoint for with large lists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 07:57:38 +0300

I think that 300000 throughout the entire site is probably OK but I imagine
you would have to divide them up in many different forms libraries.

I'm fairly sure there's a limit to the number of documents per library
somewhere. I have about 500 as my max which is no problem (so the limit's
higher).

It might be that you need more than one content database too to cope. (That
capacity paper is looking a better choice by the minute)

This paper includes capacity planning
http://www.microsoft.com/technet/prodtechnol/office/sps2003/downloads/msidwnld.mspx
but it's not the one I'm really looking for.

There's this webcast
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032241882&Culture=en-US
TechNet Webcast: Planning and Sizing a SharePoint Portal Server 2003
Implementation - Level 200

(which also isn't).

The one I'm looking for is an SPS 2003 paper by Kimmo Forss - maybe you can
find it yourself. It's been referred to here recently (so Google Groups
Advanced Search) and its an MSDN paper if I remember right.

Mike Walsh, Helsinki, Finland

"PHYTOSAN" <it@diphytosan.com> wrote in message
news:0ebc01c4bab6$789bb0e0$a501280a@phx.gbl...
> Good points. We can upgrade to SBS2003 premium without
> major problems. As to the machine: 300'000 a year is a
> bout 1 per minute, so there would be very little actual
> load on the server.
>
> IT
> >-----Original Message-----
> >I would think that with SBS 2003 standard edition your
> problems would be
> >more
> >
> >a) can one single machine handle all this
> >b) can you survive without Search (which only SQL Server
> makes possible and
> >you have only WMSDE in SBS 2003 *Standard* Edition.)
> >
> >There's a capacity planning paper for SPS 2003 that
> otherwise you can check
> >for sizes. (also relevant to WSS)
> >
> >Mike Walsh, Helsinki, Finland
> >WSS FAQ at http://wss.collutions.com
> >Please post questions to the newsgroup only.
> >
> >
> >"phytosan" <it@phytosan.com> wrote in message
> >news:0cb401c4baaa$24370a10$a601280a@phx.gbl...
> >> We are considering using sharepoint in a mass
> prodcuction
> >> environment where up to 300'000 data sets would be
> >> generated every year. Would it be feasible /
> recomendable
> >> to store such amounts of data in a sharepoint form
> >> library or would we need to go another route. (SBS2003
> >> Standard edition with WSS)
> >>
> >> Thanks
> >>
> >> IT
> >
> >
> >.
> >

Relevant Pages