STP ODS Html drill down application files caching

NKey11 — Wed, 23 Mar 2016 14:45:59 GMT

Hi All

In SAS example /Products/SAS Intelligence Platform/Samples/Sample: Shoe Sales by Region code:

%let _ODSOPTIONS=%str(body=region1.html newfile=table);

%STPBEGIN;

proc report data=work.shoes nowd;

column region subsidiary product sales inventory returns;

define region / order noprint "Region";

define subsidiary / order "Subsidiary";

define product / order "Shoe Style";

define sales / sum "Sales";

define inventory / sum "Inventory";

define returns / sum "Returns";

break after subsidiary / summarize suppress style=Header;

break before region / page ;

compute before _page_ / center style=BeforeCaption;

line "Men's and Women's Shoe Sales Figures for " region $25.;

endcomp;

run;

* Use STPEND to close the HTML output destination so that ODS will

* write the appropriate HTML to mark the end of the documents that

* have been created.

%STPEND;

enables creating html files referred by links for each region.

My question is: when I try to create large number of files (let's say 1000) the first redirection from clicked link in SASPortal takes for example 10-20 second. And then every next navigation between links takes 1-3 seconds (seems like in a meantime some caching or optimalization was made). Is there any solution to force quick file searching (caching) in such case, not to wait longer for the first time ?

Best Regards

Norbert

Re: STP ODS Html drill down application files caching

Cynthia_sas — Thu, 31 Mar 2016 12:25:36 GMT

Hi, Norbert:
It sounds to me like something in the browser is still loading or hasn't finished loading when you click the first link.

I don't know of any option to force or impact caching. This would be the kind of thing where I would recommend you open a track with Tech Support. They are much better at performance type questions than anyone else I know.

cynthia

Re: STP ODS Html drill down application files caching

NKey11 — Thu, 31 Mar 2016 12:40:28 GMT

Hi Cynthia

Thank you for your time. I will try to tackle this problem with TechSupport then.

Best Regards

Norbert

topic Re: STP ODS Html drill down application files caching in Developers

STP ODS Html drill down application files caching

Re: STP ODS Html drill down application files caching

Re: STP ODS Html drill down application files caching