Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Joined Dataview Performance

Asked By: Lolly Betz Date: Sep 21, 2011 Category: Sharepoint Views: 784

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?

Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:joined dataview performance

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.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Document Library Field Querying by End User at 'run time' - Sharepoint 2010

Next: The Document Information Panel was unable to load.

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.