Poor report performance with Ora10

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
isoyuki
Posts: 0
Joined: Wed Mar 07, 2018 4:04 am

Poor report performance with Ora10

Post by isoyuki » Wed Jan 30, 2008 12:04 pm

Hello,____I have a report setup that uses a calculated field with the following expression:____DATE()____After upgrading my database to Oracle 10 this report now takes approx 10mins to run. If the calculated field and expression are removed it runs in seconds as normal.____I^ve tested on Oracle 9 and lower, it works fine. Why is the query being handled differently in v10?____Please advise????____Thanks____Paul
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Poor report performance with Ora10

Post by kfleming » Thu Jan 31, 2008 10:34 am

Edit the expression to use RR(DATE()) and see if that helps.____Kathleen__R&R Support
Top
isoyuki
Posts: 0
Joined: Wed Mar 07, 2018 4:04 am

==> Poor report performance with Ora10

Post by isoyuki » Fri Feb 01, 2008 7:47 am

Great stuff, that works.____Thank you____Paul
Top
Post Reply

Return to “R&R ReportWorks Users”