DataProcessingExtension - Caching in connection-object

Hi,

I've made a Data Processing Extension that fetches datasets from the business layer. These datasets contains several datatables. But for one report, the different dataregions is dependent on different datatables in the dataset, and therefore I have, in the report designer, made one "Report dataset" for each dataregion.

But my concern is perfomance. For each "Report dataset" the same fetch method is called to the business layer, and data for all the "Report datasets" are fetched each time. I would like this to happen once and only once for each report-request.

Is it possible to cache the dataset in the connection-object (IDbConnectionExtension) When does the report server call this connection If it is once and only once for each report, this sould be easy. Any other suggestions

Regards, Tomsi



Answer this question

DataProcessingExtension - Caching in connection-object

  • DataProcessingExtension - Caching in connection-object