How to speed up performance metrics streaming time?

Question

I am trying to get a better understanding of the performance metrics test in OAC. After we moved all the workbook calculations to my database view, my workbook is very slow. Ideally, since we moved all the case when calculations to the table view it was supposed to perform better. I am trying to understand what I can do to enhance its performance. at the moment streaming time is taking longer than it should, is there anything I can do to reduce the streaming time?

Federico Venturin - Oracle · Accepted Answer

Hi @User_SFA90 ,

Which object are you using to access to your data? A subject area? A dataset?

Where is data stored? In OCI? on-premise?

Are you using a view or a materialized view? How many calculations do you have in it?

Have you tried to run the physical SQL code generated by OAC directly in the database? Does it run faster?

Gianni Ceresa · Accepted Answer

since we moved all the case when calculations to the table view it was supposed to perform better

What made you believe this?

If your CASE WHEN instead of being in the workbook or dataset is in the view, the real query executed by your database is probably pretty much the same: a view doesn't materialize anything, it just hide a query behind a "table-like" object. If you do use a materialized view or a table, there you should see a real difference (in case the slowness was due to the CASE WHEN logic in your queries).

If a workbook takes more than 5 minutes, you should easily be able to identify what is really happening when you execute it, where these 5 minutes are really spent.

With a query time of more than 5 minutes and just 12 rows returned from your database, if you want to improve performance, you maybe need to have somebody look at that query, see if there are some quick-wins like indexes that could help, or partitions or other things like that. Including the option to materialize the result of that query so that when you open your workbook it just select 12 rows without first running a heavy query.

Steve F-2 · Accepted Answer

"Streaming time"  is external to Oracle Analytics. It generally indicates an issue with network, proxy, browser, client machine, etc. that you need to look into.

You can hover your mouse over the 'Streaming Time' row under the 'Request Statistics' column for a definition.

You may want to start with an HTTP Archive (HAR) capture.  Please do NOT post the HAR file here in the public forum (it would need sanitization, as it contains private network, etc. information).

It may give you a clue as to what is taking time to load in the browser.

You also need to review your OAC architecture, none of us will know if you have external load balancers, edge servers, etc. configured.