Typical, I spend three sleepless days designing a great Sharepoint based application for my job and minutes before showing it off to some colleagues it begins to run incredibly slow.
For those who google a solution for something similar here are some phrases I think you might be searching for:
- Sharepoint dvwp slow
- Moss data view slow
- sharepoint designer new item form slow
The situation:
Have a web part page with multiple web parts, one or more are causing the pages to load slowly, but no errors are thrown.
The Culprit:
One web part, specifically the DVWP “new item form” was intended to allow the user to add a record to a list that already had about 1400 items. Not too big, in my opinion. In fact, I have other lists and corresponding “new item forms” that are larger and load much more quickly. Why this particular one was causing me to go grey, I still have no clue.
The Solution:
Be forewarned, this makes no sense. I established a filter on the “new item form” that looked for items that were modified in the future. Yep, you read that correctly. I basically determined that due to some shortcoming of SPD it must have been traversing the entire list upon page load (at the browser), needlessly as this particular web part was for adding a new record. So to eliminate this needless iteration, I thought I’d try to reduce the number of records it would receive by introducing a filter. It worked for me… hope it helps someone out there save some time.
