Category / SharePoint 2007

by Simon Doy

>SharePoint Memory Leak (one for the geeks)


>

Introduction

Todd Carter has found a core issue with SharePoint 2007 relating to the way that memory is disposed. Over the past couple of years memory management has become quite a hot topic and best practises have been published such as ensuring that you dispose of certain SharePoint objects (e.g. SPSite and SPWeb) after using them. These discoveries have lead to tools such SPDisposeCheck being released.

Todd however thought there was more to it and has investigated into SharePoint’s memory usage even further and uncovered a bigger issue.

An interesting article delving into the internals of Sharepoint, explaining the problem and then providing a workaround, a full fix is due shortly.

Funnily enough SharePoint 2010 does not seem to suffer from this problem, maybe thats a good reason for a client to upgrade!

http://todd-carter.com/post/2010/02/08/SharePointe28099s-Sasquatch-Memory-Leak.aspx

by Simon Doy

Reporting Services and speeding up reports with Images


Recently I have been working on some reporting services report interfaces and do hope to blog about this in more detail later.

Until then though I would like to share some pain points that I have had particularly when using images within Reporting Services.

Two issues come to mind:-

  • slow rendering
  • columns containing images not being sized correctly.

Slow Rendering
So one of the issues that I had is slow rendering of the reports. To explain the scenario a particular column uses images to display the status of the column. The images are changed via an functional express based on a status id field. For a certain status the client did not want to see an image, to achieve this, the image was set to “” to indicate no image.

However, as more images were used the rendering of this column became really slow. To solve this, I created an image called ‘blank’ that was a 1×1 pixel PNG image which is embedded in the report. Instead of using “”, I would use “blank”. This seems to speed things up, in fact doing some testing, the report now loads up after a refresh of IIS app pools and the Reporting Services report in 24 seconds opposed to 85 seconds!

Columns Not Sized Correctly
When the report was rendered columns that had images would sometimes not size correcly leaving a big space after the image. Sometimes the column would fix itself and other times not, it took me a long time to get a solution and this is what I had to.
First ensure that the image properties->size is set to original. Also add padding of Top=1 and Left=1.

This combination seemed to fix the issue.

Hope that helps.