Data Driven Subscription - Open Connections

Hi,

I'm trying to run a data driven subscription on a report in the rs2005,

and using a data source to oracle,

I found out that when the subscription runs it opens a connection to oracle for each report and it means that i have more than fifteen open connections every time which causes a performance problems

did anyone encounter this kind of problem

pls help

Data driven subscriptions runs the report for each row you return in your delivery query.

You can minimze the impact on the underlying RDBMS by changing the execution mode of the report to cache or snapshot. The first will ensure the minimal number of query executions occur on your underlying RDBMS. The second option will ensure only one query execution will occur (whenever the snapshot is updated). This has some benefits, but may require you to update your report to filter content for each user.

Hope that helps,

-Lukasz

|||

Is this report going against transaction tables, is that why there is a performance problem? If for some reason you can't do what Lukasz suggests maybe you can snapshot or cache the data yourself (whether in Oracle or an external mart somewhere)?

This way you massage the data once up front into the form your reports need, take the load off your transaction tables, even avoid any potential licensing issues on the Oracle side if that has been a concern with these connections.

There are probably a lot of ways to skin this particular cat <s>.

>L<