Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Page report load too slow
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Page report load too slow
 Login/Join
 
Member
posted
Hello,

I have a table in AWS Athena that contains around 1.4 million rows and that is connected to WebFOCUS. I created a report with filters in InfoAssist then a page for the report with the search bar (filters).
Because of the large amount of data in the report, the page takes more than 30 min to load the search bar (the report itself takes longer), but as soon as the search bar is loaded, i'm able to search in the report and within seconds display the data i need from it.

In infoAssist i tried the active cache option by choosing active report but it's still taking more than 30 min to load.

Does anyone know how to fix the issue please.

Thank you in advance.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 5 | Registered: April 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I think in InfoAssist's Format Tab there's a button for Pages on Demand. Turn that on and try your report.


WebFOCUS 8206, Unix, Windows
 
Posts: 1741 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
Thank you for your quick reply, unfortunately i can't find ON-demand paging anywhere on the tabs. could it be a feature that the client doesn't have?
 
Posts: 5 | Registered: April 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What version of WebFOCUS are you using? It's a part of InfoAssist.

https://webfocusinfocenter.inf...30-8FD3-225FEE3ABEE1


WebFOCUS 8206, Unix, Windows
 
Posts: 1741 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Why don't you hold off on the display of the report till after they apply / submit their filters?

This message has been edited. Last edited by: Doug,
 
Posts: 3050 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by BabakNYC:
What version of WebFOCUS are you using? It's a part of InfoAssist.

https://webfocusinfocenter.inf...30-8FD3-225FEE3ABEE1


Release 8.2

In format tab > Navigation i only have a choice between : Table, Table of contents and Freeze. There's no on demand paging
 
Posts: 5 | Registered: April 29, 2019Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by Doug:
Why don't you how off on the display of the report till after they apply / submit their filters?


I would like to but How do i do that?
 
Posts: 5 | Registered: April 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you have access to Administration Console under Configuration, InfoAssist Properties, check to see if Enable Pages On Demand is checked.


WebFOCUS 8206, Unix, Windows
 
Posts: 1741 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by BabakNYC:
If you have access to Administration Console under Configuration, InfoAssist Properties, check to see if Enable Pages On Demand is checked.


Unfortunately the option of On-demand paging is not available. For now i used filters (parameter-simple) which allows the user to enter and search for the values without having to load all the data first.
for now it seems the only option for a large amount of data.
 
Posts: 5 | Registered: April 29, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
I would like to but How do i do that?

We need to know how and where this report is being executed in order to answer this question.

Is this being done on a page in a portal? Is it in an iFrame? What release are you using? Anything else would be helpful.

PS: I cam across this post while searching for 'aws'...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3050 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Page report load too slow

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.