Friday, December 02, 2005

 

Report performance

One success today...a managed to get report that was taking 15 mins to produce in Sql Reporting Services down to a few seconds. In the end I had to resort to a database job top to pre-calculate a bunch of the data I needed in the report rather than figuring it out on the fly. The downside is the report data is now only as fresh as the last time the database job ran - but given that the source data for this is only received daily its not a big deal...

Comments: Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?