SSRS Performance issue

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  April 23, 2015 at 9:18 am

  #300104

  Hi,

  I am developing report where my data source is Oracle. I am not using SP and currently not a parameter in a query, Just select statement.

  Now my issue is that query in oracle is running in 7 seconds but when same query in SSRS i am integrating, SSRS report is taking a time, even i tried 4-5 times and waited almost for 10 mins but not data displaed so i aborted the same.

  Please help as this task is on high priority.

  Thanks

  Abhas.

• Jo Pattyn

  SSC-Dedicated

  Points: 32074

  More actions

  April 29, 2015 at 9:37 am

  #1794359

  How are you quering Oracle through SSRS?

  Using SQLServer as a datasource and using the LINKEDSERVER..SCHEMA.TABLE / OPENQUERY notation

  Or Using Oracle as a datasource?

  Is it possible to post the query?

• Jamie Ingram-729524

  SSCommitted

  Points: 1573

  More actions

  December 6, 2016 at 11:53 pm

  #1916411

  Hi

  Put your query in a Stored Procedure so that it gets a saved execution plan.

  Try the Attunity Drivers for Oracle.

  Cheers

  Jamie

  We are the pilgrims, master.
  We shall go always, a little further.