You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI report has increased massively since 26B

Hi,

A report that was taking 9 seconds to run is now taking 706.

This is since 26B came in on Monday.

I will attach the report xml, and I have run a Performance check using the OTBI Performance subject area but am unsure why the report is suddenly taking so long to run for a report that only contains around 90 rows.

There is a couple of and/or filters but they have not been changed for weeks.

It looks like the problem is with this filter because when I remove the OR it reduces the speed back to around 9 seconds.

Can anyone advise how I can work out what the problem is or advise what I should be looking for to fix this problem?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!