I have a Windows Forms application that uses SQL Server 2005 Reporting Services and displays the reports in the application using the ReportViewer control. As soon as one report is run, the entire site degrades dramatically and does not improve speed until IIS is reset. My VB.NET code is pulling two tables from a database and dumping it to a DataSet. Table one has around 4000 items, and table two has around 16000. Filling the DataSet takes about 1 second. I'm using the version of CR that comes with VB2k8 Pro by the way if that helps. Also, how does result set caching work?
Bookmarks