As mentioned earlier this year in the first installation of
this article series, it can be useful to have information on the performance of
our BI tools. The purpose of this load testing article is to give some
understanding into where caching can help improve performance.
The BI tools used here are running on the web. In that first
article, the testing was performed on standard Crystal reports. Now we show how
to use the High Shareabliity Caching and test the reports using that model.
The High Shareablility Caching model is for reports with
underlying data with minimal changes (think data warehouse). Also, if the
parameters will be similar or run often, this report is a good target for high
Visual Studio 2008 Team Suite (Developer and Test Edition used)
Crystal Reports 10
SQL Server 2005