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] HTML Composer: How to Speed up Drop-down Box Load times with Procedure
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] HTML Composer: How to Speed up Drop-down Box Load times with Procedure
 Login/Join
 
Platinum Member
posted
Hello,

I'm wondering if someone could advise me of a best practice for including external procedures in drop-down boxes generated in an HTML Composer page.

Even with limited records (282), the HTML page takes around 10 seconds to load which to me seems a little crazy. The code I am using is:

 

TABLE FILE MAPMMPLANTOSERVICETYPE
SUM
	COMPUTE CLIENT_TYPE_FIN/A100 = IF CLIENTTYPE EQ 'PopHealth' THEN 'Population Health' ELSE IF CLIENTTYPE EQ 'FinancialRisk' THEN 'Financial Risk';
BY  MAPMMPLANTOSERVICETYPE.MAPMMPLANTOSERVICETYPE.CLIENTTYPE
BY  MAPMMPLANTOSERVICETYPE.MAPMMPLANTOSERVICETYPE.MARKETTYPE
BY  MAPMMPLANTOSERVICETYPE.MAPMMPLANTOSERVICETYPE.CLIENTNAME
BY  MAPMMPLANTOSERVICETYPE.MAPMMPLANTOSERVICETYPE.GROUPNAME
BY  MAPMMPLANTOSERVICETYPE.MAPMMPLANTOSERVICETYPE.GROUP_CD
WHERE CLIENTNAME IS NOT MISSING
WHERE GROUP_CD IS NOT MISSING
END

 

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
 
Posts: 138 | Registered: July 10, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You don't seem to have any parameterised constraints on that procedure, so you could just cache the results into a HOLD-file and use that instead.

If that still takes 10 seconds, perhaps you're looking at a DNS issue (10s is a default DNS timeout).

Does the procedure still take 10s when run separately? If that's the case, you need to look at the underlying storage. How many rows are in that table? Do you have appropriate indices?

Is this a table in an RDBMS and is the request perhaps executed through a FOCUS managed JOIN?


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 :
 
Posts: 1664 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
I have the same problem. I created a fex that will read my database and put the fields I want into a permanent focus hold file, and then I use the hold file in the dropdown. It's way faster than reading it from our database for some reason. I extract the database table into the hold file nightly via ReportCaster so the hold file and dropdown are up-to-date.


Webfocus 8
Windows, Linux
 
Posts: 256 | Location: Palm Coast, FL | Registered: February 05, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
@Wep5622. Thanks for your response. The procedure takes maybe a second to run. There are 200 rows in the table. I don't think that's a ton. When you say cache the results, do you mean saving it in an app path such as:

 

ON TABLE HOLD AS 'LOCATION/HOLD_FILE'

 


@Mike

ohh good point. So do an app path. Thanks Mike. Yeah I was considering that. Thankfully these menu selections won't be too hard to maintain. I'll give this a whirl and let you all know.

Appreciate it!!


WebFOCUS 8204
 
Posts: 138 | Registered: July 10, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
ok here's my solution. I run my procedure, hold it in foccache and then include the filter panel after the procedure runs in a .fex wrapper. I shaved 4 seconds off load time. I think this is sufficient.

Code below:

 

TABLE FILE CAR
SUM
	COMPUTE CLIENT_TYPE_FIN/A100 = IF COUNTRY EQ 'FRANCE' THEN 'Population Health' ELSE IF COUNTRY EQ 'ENGLAND' THEN 'Financial Risk';
BY  COUNTRY
BY  CAR
BY  MODEL
ON TABLE HOLD AS 'FOCCACHE/TEST'
END

-HTMLFORM IBFS:/WFC/Repository/CM_Performance/Common_Content/CM_TEST.htm

 


Then I have a separate .fex that has the final table in it that the HTML composer uses.

Thanks for your help all.


WebFOCUS 8204
 
Posts: 138 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] HTML Composer: How to Speed up Drop-down Box Load times with Procedure

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