Home » Developer & Programmer » Reports & Discoverer » Query is Fast But report is slow
Query is Fast But report is slow [message #225994] Thu, 22 March 2007 04:07 Go to next message
pankaj Rathee
Messages: 3
Registered: July 2004
Junior Member
Hi,

I have a query which is very fast when i run it in Toad or SQL Plus but when i am running the report based on that query in report builder 6i it is either taking a long time to complete or erroring out with temp table space full error.I am not using any formula columns or program units in this report.It is taking 2 sec in Toad and SQL Plus but 25-30 minutes in report builder.I am attaching the query as attachment.
Re: Query is Fast But report is slow [message #226009 is a reply to message #225994] Thu, 22 March 2007 04:58 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi pankaj,
u must tune your query OR see how much buffer space allocated for you for reports .
AT
Re: Query is Fast But report is slow [message #226949 is a reply to message #226009] Tue, 27 March 2007 00:24 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Could it be that in TOAD you're only retrieving the first n rows? Because Reports doesn't tend to use more temp tablespace than the query itself... So, like AT mentioned, tune your query first.
Re: Query is Fast But report is slow [message #227093 is a reply to message #226949] Tue, 27 March 2007 05:59 Go to previous messageGo to next message
pankaj Rathee
Messages: 3
Registered: July 2004
Junior Member
Hi AT,

I have tried it in SQL Plus also and there also it is running very fast.I have also checked the explain plan of the query and this seems to be ok.

Regards
Pankaj
Re: Query is Fast But report is slow [message #227331 is a reply to message #227093] Wed, 28 March 2007 01:02 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Hm, maybe some reports expert can explain this? (I can't...) Littlefoot, do you have any suggestions?

Still, I would examine the qeury in the report closely because like I said, tools (like reports) don't use temp tablespace, so it's just about impossible that the query is fast in SQL and generates a temp tablespace error in reports.

The report is run under the same user? Same database? Same tables? No views in between or something?

Re: Query is Fast But report is slow [message #227599 is a reply to message #227331] Wed, 28 March 2007 14:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea either ...

Are you, perhaps, creating a PDF file and downloading it from a remote location which suffers from a slow connection (dial-up, for example)?
Re: Query is Fast But report is slow [message #251152 is a reply to message #225994] Thu, 12 July 2007 09:25 Go to previous messageGo to next message
prasad.viji
Messages: 12
Registered: December 2005
Location: pondicherry
Junior Member


Dear,

I am also faced the same problem,that is , the data are more larger the nested query does take the time for 25 - 30 minutes ,so try to tune up the query and insert the record into the temporary table and in ur report builder use the temporary table

note : before calling the report do all this procedure

Thanks
Prasad.D
Re: Query is Fast But report is slow [message #296927 is a reply to message #251152] Tue, 29 January 2008 08:56 Go to previous message
maxapp
Messages: 2
Registered: January 2008
Junior Member
We've had a similar problem from many our customers.
The solution is very simple (if the problem is the same). Try to do an update (not real, for example rewrite a comma) to the report query, rebuild the rep and try again.
After that our query has become fast in the report too.
Previous Topic: disable options "drill to related items"
Next Topic: REP-51002: Bind to Reports Server repserver failed
Goto Forum:
  


Current Time: Sun Dec 11 06:23:09 CST 2016

Total time taken to generate the page: 0.07021 seconds