Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IR Filter Performance

760169Mar 15 2010
Hi,

I have a large query behind an IR that returns approx 30,000 rows.
Now when i try to use the IR filters on this report they take a very long time 1-3min to load the available values.
This is even worse when you click on the column heading to find a list of the available values.
Does anyone know what apex does behind the scenes here and what may be able to be done to improve performance?

Thanks
Adam

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 12 2010
Added on Mar 15 2010
#apex-discussions, #filter, #performance
0 comments
222 views