Focal Point
[CLOSED] Hyperstage Performance Active Reports

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8927055096

July 16, 2018, 06:35 AM
jenni
[CLOSED] Hyperstage Performance Active Reports
Hi,

I created an Dokument, Format Active Report.

The Problem is it is quite slow and even if I Change my Metadata sothat I use Hyperstage, there's no improvement...

Does soemone know ehy?

My Dokuments contains like 7 Charts/Reports, which interact with eachother beacause of my Dokument funktionality. It's all created with InfoAssist, so ne really complicated Actions.

My Metadata containes (all in all) like 150.000 Entries - not really a lot.

Would be thankful for help!!

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


WebFOCUS 8.1.05
Windows, All Outputs
July 16, 2018, 09:02 AM
BabakNYC
What's the source of your data? SQL Server, DB2, Oracle.....

Do you have JOINs, DEFEINs or COMPUTEs in your content?

If your data is in an RDBMS, I suggest you run with SQL Trace to see what kind of SQL your code is generating. Perhaps you can change things in the code that'll make your document run more efficiently.


WebFOCUS 8206, Unix, Windows
July 16, 2018, 09:31 AM
TexasStingray
What do you mean by slow, slow to generate the Active Report, Slow when interacting with the report(s)? You can see how long to take to run just my saving it to a file as and AHTML file.




Scott

My Source is Oracle. I have some defines (just 4 or 5).

It's slow with interaction of the reports.
And - and that's what bothers me, it's not fasten then when I create the exact same Report with the Oracle source. So no difference between hyperstage and no hyperstage..


Is there in General a mentionable difference between using hyperstage in normal reports and Dashboards and Portals (not only visualizations, cause there it is really an improvement) then not using hyperstage?
Or is it really only useful in Connection with visualizations???

Thanks a lot


WebFOCUS 8.1.05
Windows, All Outputs
Isn't interaction of ActiveReports done in the end-user client? That's the whole point of ActiveReports, isn't it?

In that case, the database, Oracle or HyperStage, only comes into play for creating the ActiveReport. The interaction is done within the client; no database gets involved from that point.

Hence the lack of difference between your sources. The client (browser or mail client or some such) is the bottleneck.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
Jenni do you have Infoassist+ ? If yes, then better use Visualisations for this.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
Thanks @Wep5622, that seems to be the reason, and seems Logical... sadfully

@Frans: I tried the same with Visualizations, but Active Reports has more, for me important, Features...

So thanks Smiler


WebFOCUS 8.1.05
Windows, All Outputs
For large active reports, client-side performance will be mainly dependent on the amount of memory and the CPU speed of the system that the receiver of the report is using. I assume you can't very well tell your customers to plug in more memory...

Another issue may be network latency, especially on flaky wireless connections (for example in a factory full of big whirring machines causing interference).

You may be able to improve all these by reducing the amount of data you send to the report. Don't send unnecessary fields, keep your field sizes tight, use variable length fields (/AnV instead of /An), aggregate where you don't need details, etc.

Going further (and probably overboard), perhaps you can "pack" (parts of) your dataset for the report and have the report "unpack" it on the fly - but that will hit the CPUs on both ends of the line.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :