Hi Telerik Team,
We are facing a similar issue. There is a Telerik report with two datasources. Queries of the datasources when run in SQL server directly shows result withing 4secs. The same query when run by the report either times out or takes a long time to show up.
Connectionstring is dynamically updated. There are 6 tables in the report with one row each. When the row is clicked, another report opens.Parent report takes a long time to load for the first time. Child report opens quickly.
CommandTimeout is set with value 600. Connection Time-out in IIS is set to 601. Still there is no improvement. On running 'dbcc freeproccache' in SQL server, the report gets generated in a few seconds. But, the next time report is generated, the issue is back. We are working with ASP.Net Webforms Telerik Reporting 18.104.22.1687.
Please suggest what could be wrong and what could be done to see the report quickly. Running 'dbcc freeproccache' often is not feasible.