Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Joined Dataview Performance

  Asked By: Lolly    Date: Sep 21    Category: Sharepoint    Views: 1534

I have created a joined dataview web part using a sql database connection and a Sharepoint list. I am also using the currentUser filter and then matching the client number in the sql to the client number in the list. Everything is working but the performance is not good. It is taking almost 15 seconds for the page to load.

If I don't try to match the client number, it is very fast so the problem seems to be matching up the 25,000 sql rows to the 200 list rows.

I have read that there are dataview performance issues using joins and connected web parts. Is there a way to overcome this?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Joined Dataview Performance Or get search suggestion and latest updates.