Liveware Publishing Support Forum

Posted: **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

Posted: **Thu Jan 31, 2008 10:34 am**

Edit the expression to use RR(DATE()) and see if that helps.____Kathleen__R&R Support

Posted: **Fri Feb 01, 2008 7:47 am**

Great stuff, that works.____Thank you____Paul

Liveware Publishing Support Forum

Poor report performance with Ora10

Poor report performance with Ora10

=> Poor report performance with Ora10

==> Poor report performance with Ora10