http://www.endusersharepoint.com/STP/ SharePoint QA en Tue, 26 May 2009 23:33:49 +0000 http://www.endusersharepoint.com/STP/topic/data-access-methods-in-wiki#post-6949 Fri, 22 May 2009 02:38:05 +0000 dwinter 6949@http://www.endusersharepoint.com/STP/ <p>I can no longer see that post.</p> <p>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. </p> http://www.endusersharepoint.com/STP/topic/data-access-methods-in-wiki#post-1046 Mon, 08 Sep 2008 19:51:25 +0000 deliafrog 1046@http://www.endusersharepoint.com/STP/ <p># 2. This is related to the <a href="http://www.endusersharepoint.com/STP/topic.php?id=62#post-253">Maximum Number of List Items</a> post from last month.</p> <p>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)</p> <p>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? </p>