Stump the Panel » Site Managers and Site Collection Managers

Data access methods in wiki

(2 posts)
  • Started 8 months ago by deliafrog
  • Latest reply from dwinter

  1. deliafrog
    Member

    # 2. 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 by developing a custom interface and using certain SharePoint data access methods. We want to migrate between 10,000 and 20,000 total records from a SQL database to a SharePoint Wiki. So here is question two (first question was in a previous post)

    2. Can the SharePoint techniques mentioned in the White Paper (SPList, SPQuery, SPListItems, PortalSiteMapProvider) be implemented within a wiki library without breaking wikiContent colmumn/functionality (wiki linking) and without creating a complete custom wiki solution?

    Posted 8 months ago #

  2. dwinter
    Member

    I can no longer see that post.

    You would want to restrict your #of items in the view to a reasonable number. The larger it is, the worse the perf. Also, you want to set up an index on the primary key for the view. If you are grouping by ID, you're fine, if you sort on some other pivot, ensure the column indexes are configured appropriately. Then start loading in your data and testing. You should be OK if you follow those rules.

    Posted 3 days ago #

RSS feed for this topic

Reply

You must log in to post.