In SSRS, I noticed that the rdl.data cache files are being stored on my dev machine. Are these files also stored on the Reports Server when reports are run? If so, is there a way to avoid creating those files on the server?
+3
A:
rdl.data files aren't created on the server - they're purely to speed up report execution time during development when you repeatedly run the report with the same parameters whilst tweaking the layout.
As a side point, I believe it's true to say that it's possible to configure the SSRS service to cache results for reuse.
I don't know the details of the caching mechanism that the service uses; it might use a file-based mechanism like rdl.data, or it might store the results in one of the ReportingServices databases.
Perhaps someone more knowledgable about SSRS can confirm the details of the mechanism.
Ed Harper
2010-08-06 15:46:22
@Ed....great info. Thanks! And if anyone would care to comment on the server side service caching configuration....I'd be very interested
MikeTWebb
2010-08-06 17:17:18
I know this is a late comment, but SSRS caching happens inside the ReportServer and ReportServerTempDB database.This might provide a starting point for understanding the SSRS caching model: http://sqlcat.com/technicalnotes/archive/2008/06/26/report-server-catalog-best-practices.aspx
warriorpostman
2010-09-20 20:37:58