Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

BDC from Sql for large record retrieval

  Asked By: Phenil    Date: Nov 27    Category: Sharepoint    Views: 1101

This question may have been asked, but my searches did not find a post so apology in advance if there is already a post.

I'm going to be using Designer to connect to SQL database of 100K plus records. I've researched white papers and they appear to use code to achieve this with little impact to performance. I don't have coding option. Any ideas? Will an IFilter webpart be able to pull information directly from the db or does the process export into list? Question being asked because of the 2000 item limit in SP Lists with out using folders.



1 Answer Found

Answer #1    Answered By: Kai Carney     Answered On: Nov 27

Will you be displaying all 100K rows in your web part? That would be bad idea.

If you will be displaying just subset of data you should be fine. 2000 item limit on the SP list  is not hard number, it is recommended value for acceptable performance. Based on your hardware and data in the list you could have lot more items with acceptable performance. (or less)

Didn't find what you were looking for? Find more on BDC from Sql for large record retrieval Or get search suggestion and latest updates.