Oracle Communities

Oracle Analytics and AI

Child Item

OAC Lite for Performance

OAC has a lot of great options for interactivity with your data; however, it comes with performance sacrifices. I would like to be able to control the interactivity within OAC so my reports can render more quickly. We all love the dad jokes that come up while waiting for your dashboard to load, but sometimes you get 3 or 4 dad jokes to load for a basic graph. That makes it slow in OAC and especially slow when we're embedding OAC into other applications. My specific use case is I am embedding OAC DV content into APEX. If I compare the same chart built in APEX versus OAC, the APEX chart renders significantly more quickly due to the fact that it's "no frills" and has less to do upon load time.

I would like to suggest that OAC should create an "OAC Lite" as an option to turn off some functionality to improve the load performance.

Find more posts tagged with

oracle apex

Performance

OAC

Needs Votes

Data Visualization

Status: Needs Votes

Comments

Branden Pavol

Here is an example of OAC DV on top and APEX on the bottom. The OAC graph takes about 10 seconds to load versus the APEX graph takes less than 1 second. I should get the option to "load quickly" or something like that on the OAC side so it can load approximately as fast as APEX.

Mike Durran-Oracle

Thanks for logging this Idea Branden.

Michal Zima

@Branden Pavol Hi Branden - our experience is that initial loading of DV workbook takes substantial amount of time, which dramatically degrades the user experience. See following Idea:

https://community.oracle.com/products/oracleanalytics/discussion/comment/61120#Comment_61120

which deals with this topic. So instead of having some "lite" version (btw you can disable quite a lot of interactivity in workbook for consumers, including brushing for example, which has quite big performance overhead as well) , concentrating on improvement of initial workbook loading time would solve quite a lot.

Dan Vlamis

I just wanted to weigh in and agree with my two cents worth…I agree it's not the creation of an "OAC Lite", but rather some sort of "mode" that OAC is in. Whatever OAC is doing when starting up or loading a workbook just takes too long. Give us some sort of mode that turns off some the functionality that we don't need and make us incur that load when we need the functionality. Somehow make it faster.

Thanks.

Greg Faris

The load time of DVs from a consumer perspective has long been a complaint from our users. We've worked over the years with Oracle, but never come up with a solution. I do think it's the large amount of code that is downloaded to handle what's needed regardless of if it's being used. We've even noticed that unused plug-ins are downloaded even if they're not referenced in a DV - which leads me to believe that it may possibly down the code for all visuals even if they're not used in a specific workbook at all.

It would be great to have this code streamlined - at least for people that only plan on viewing the report (not developing it).

Dan Vlamis

Thanks, Greg, for your thoughts. I, too, have seen the load time increase over the years and I have clients that have complained. What I do NOT know is how much Oracle has really looked at improving the load time. I have not personally looked at the bytes that come down when an OAC workbook is loaded, nor have I seriously pushed the issue with Oracle. My thought is that THIS COMMUNITY is a place to air those concerns.

Also, <shameless plug> we can voice these concerns in person as a community at Analytics and Data Summit at

Summit-Analytics-AI-Oracle

taking place April 8-10, 2025 on Oracle's Redwood Shores campus. IMHO, this is the type of thing that an Oracle user community should be researching and advocating for. </shameless plug>

I think we all just want to work with Oracle to make it the best Analytics platform possible.

Dan Vlamis