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     [CLOSED] Active Report(AHTML) Performance issue
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Active Report(AHTML) Performance issue
 Login/Join
 
Gold member
posted
Hi,

I have created an active report about 200,000 records within. and I insert this active report into a "page" with some filter to set 'Default' value. The problem is, it take extremely long(like 4min. or more ) to show the Active report. I did couple research find out could be the distance of network?

I check session agent in WebFOCUS server, there is only one agent is doing this job, wander if possible for multiple agent to process this job to speed up the process?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS v8.2.06 , Windows
 
Posts: 90 | Registered: August 29, 2019Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi David,

I do have:

ON TABLE SET LINES 50
ON TABLE SET WEBVIEWER ON
ON TABLE SET CACHELINES 100

and it still take long to process....

any other idea?


WebFOCUS v8.2.06 , Windows
 
Posts: 90 | Registered: August 29, 2019Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi David,

Thank you for reply, I don't think is relational DB issue, because I do get original source tables from MS SQL Server and we transfer to Hyperstage due to "Only Read" permission on MS SQL Server. And I think we not suppose to query from Running DB to avoid performance issue.

So I did all graphs and reports from Hyperstage.

any idea I should try?


WebFOCUS v8.2.06 , Windows
 
Posts: 90 | Registered: August 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Why a report of 200,000 records? Who needs to see that many?
If I recall correctly AHTML shouldn't be over 10,000.
I would reduce your report to 5000 records max.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1961 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Nox

I agree with Danny 200,000 records is way too many for any report but especially and active report, it is not the record retrieval time it is generating the html output taking too much time.

The following is from the active technologies manual.

Because all post-retrieval processing is performed in the memory of the web browser, an active report has a processing limit of approximately 5,000 records or 100 pages of output. The active cache option enables you to send only the first page of active report output to the browser and retrieve subsequent pages from a temporary cache on the WebFOCUS Reporting Server. The server also becomes the resource for performing all calculations, sorting, and filtering when active cache is enabled. Since active cache uses on-demand paging functionality, WebFOCUS Viewer is not supported.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1946 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,

Thank you all for the reply. Yes I did notice 200,000 record would be insane to view, so we setup some filter to drop down record to only 60 records via filter month on "2020/04" on initial load. but it still take like 3~4min. to load.

So I think maybe because some of filter is set as "WITHIN" and then I filter out only certain value to show within filter, and I think in background it do some processing to filter all 200,000 records to try sort out those result and then return to filter in AHTML.
Just my thought.


WebFOCUS v8.2.06 , Windows
 
Posts: 90 | Registered: August 29, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Active Report(AHTML) Performance issue

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