Stump the Panel

SharePoint QA

Stump the Panel » SharePoint Workflow for All Users

1. 

   deliafrog
   Member

   #1 This is related to the Maximum Number of List Items post from last month.

   The quoted White Paper recommends avoiding performance issues in large lists by using containers/limiting the number of items per container to 2000 items. We want to migrate between 10,000 and 20,000 total records from a SQL database to a SharePoint Wiki. So here is question one (subsequent question will be in second post)

   1. The predefined browser-based SharePoint wiki library interface does not seem to allow folder creation. Can we create folders in another way within a wiki, so as to remain under the 2000 item limit? If not – what other types of “containers” might we use inside of a wiki library? Would using folders/containers break the wiki functionality within the wiki library, namely wiki-linking?

   Posted 8 months ago #
2. 

   AutoSponge
   Administrator

   What format is the raw (text) data in? NVARCHAR fields, XML, etc.?

   Posted 8 months ago #
3. 

   deliafrog
   Member

   Our main focus is two fields, term & definition. Term maps to the Name field and Definition to the WikiContent field. Both source fields are varchar.

   Posted 8 months ago #
4. 

   AutoSponge
   Administrator

   I'm not the expert on large libraries, but I know some consultants have libraries with million+ documents--they just don't try to render more than a few thousand at a time.

   You can't do folders in wiki libs but you also don't often try to look at the whole list of pages either. Make your default view something that limits to a few hundred records and go for it (on a test server).

   If that fails, there are some great, free web parts that let you display and edit SQL data in MOSS. Or, you could treat it as BDC data. Or you could convert the varchar fields to XML (with a little SQL-fu) and use the XML web part to render/edit them.

   Posted 8 months ago #
5. 

   deliafrog
   Member

   Thank you for the leads. I'll start with a large test data set and go from there...

   Please forgive me as I have been out of the development arena for about 3 years: BDC?

   Posted 8 months ago #
6. 

   ewnash
   Member

   BDC= Business Data Catalog, a data source external to MOSS like a business application or SQL data source.

   Posted 8 months ago #
7. 

   mrbun
   Member

   I agree with comment from AutoSponge, it's the View that matters, not the list size. To improve performance to impatient end users I have had some success filtering the content of lists down to a few 100, thus improving speed of delivery. BTW, I removed the view all option to prevent users crashing the system.

   With 10000 in sql I would definitely be looking at BDC, and preserve the excellent db data.

   Could always try to push the data into Access 2007 and then upload it into sharepoint lists, and filter those.

   Mike B

   Posted 2 days ago #

RSS feed for this topic

Reply

You must log in to post.