Re: over a million content items a year
- From: "Panagiotis Kanavos" <pkanavos@xxxxxxxxx>
- Date: Thu, 8 May 2008 20:38:32 +0300
"Not So Soft" means "Crawling Fails". I'ts not just a UI issue. Running SQL Server Profiler reveals the underlying cause. Back in the SP 2001 timeframe, someone added code that creates a parameterized SQL statement to retrieve documents and list items from folders that included ALL item IDs that belong to the folder in the statement. SQL Server has a limit of ~2000 parameters per query, resulting in a database error. This code is used in several places, probably everywhere folders are used.
The only real solution is to replace the buggy code. Since only MS can do that, an alternative is to abandon folders and use some other way of grouping items together. Using a "Category" lookup field for grouping is just one solution I came up with for my latest project.
--
Panagiotis Kanavos
http://www.dotnetzone.gr/cs/blogs/pkanavos
"spconsultant" <gfpilot2002@xxxxxxxxx> wrote in message news:39af23aa-fd34-47de-a84c-e1a1a97cad62@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am allso assuming content items means documents and lists. (As
opposed to HTML pages diplayed in a WCM scenario).
I like your comment of "not so soft." It does not appear to be a
question of storing them , according to the blog below,
sharepoint can handle 2 million documents in a document libray, with
2000 per folder (based on the UI problems). But the bigger question is
how to get to them, as you said the out of the box UI Falls appart, so
the limit is "not so soft."
An interesting blog with some specific numbers on limitations. (Old
date, but appears updated with V3 information)
http://markharrison.co.uk/blog/2004/09/sharepoint-scaling-limits.htm
A comment is made on this blog that you could use a new folder each
month and perhaps a new document library every yer. But this still
seems a little impractical using the out of the box interfaces. The
blog did not seem to indicate a problem with crawling, but you could
be right.
On May 6, 12:39 pm, EDAC Systems
<EDACSyst...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a question about the repository. We have a customer that generates
over 1 million content items a year. They would like to use sharepoint as
their enterprise CMS. In my research Sharepoint has a limitation of 2000
items per folder. This would cause us to have to create 500 folders per year.
Is there another way? Can I just upload the files into sharepoint document
library and when I needed a file, just perform a search. The following
metadata will be used for each checkin - Case Number, Name, year.
We would like to be able to search for years and also case numbers.
Any help would be appreciated.
Thanks
--
EDAC Systems, Inc.
Office: 540-361-1580
.
- References:
- over a million content items a year
- From: EDAC Systems
- Re: over a million content items a year
- From: spconsultant
- over a million content items a year
- Prev by Date: Themes Upgrade from 2003 to MOSS
- Next by Date: Start up for share point portal server
- Previous by thread: Re: over a million content items a year
- Next by thread: Re: over a million content items a year
- Index(es):
Relevant Pages
|
Loading
