I've obtained great results, after enabling Active Cache for a TABLE FILE command with AHTML formatting.:

 ...
 ON TABLE SET WEBVIEWER ON
 ON TABLE SET CACHELINES 200
 ...

For this particular report my user can also select HTML format.

Is there a similar environmental setting/technique, that would improve improve response time/remove answer set limitations, for HTML reports?

This message has been edited. Last edited by: David Briars,

Hi David, How did you measure the improvement as I couldn't see any difference with using those 2 commands ? Ian

Hi Ian,

In our case, we were creating an AHTML report consisting of 224,198 rows.

We've optimized the run time of the report itself, and made sure that the SQL passed to Oracle was optimzed. We also ran the SQL outside of WebFOCUS, using PL/SQL Developer, just to double-check.

Without Active Cache, the browser hangs, because of the size of the report.

With Active Cache, the first page, of the report, appears within 30 seconds. I measured this using a stopwatch website: http://tools.arantius.com/stopwatch

In our case we were using Active Cache's ability to handle large reports, as well as, it ability to yield better performance.

Regards,
Dave

Ian-

One more thing, we didn't see Active Cache work in our previous release (7.6.8). It wasn't till we went to 7.7.02, did we see the performance gain.

-Dave

Hi Dave,
Many thanks for the post. I have tested our reports with a large volume of data (150,000 rows) and the settings make a huge difference. My original report was only 5000 rows as another post somewhere mentioned not to go past this threshold. Anyway that was not big enough to test properly. Also found that when you export to Excel massive savings in time are made here too, as before, the spreadsheet opened slowly populating the rows and now it offers a dialogue box to Save or Open and when you select Open the whole lot is there immediately. I would go as far to say the these settings should be used without hestition if using FORMAT AHTML (we do not need the Webviewer for FORMAT HTML).
Merry Xmas. Ian

Ian - Thank you for the status and results.

All - I've opened a NFR with IB on this. Something along the lines of: 'Give HTML formats a 'cacheing feature', similar to what AHTML reports have, so that benefits of larger reports/better response time, can be gained.'

Hi David,
Just a quick one following on from the recent posts etc. Can you apply the SET CACHELINES 200 setting in InfoAssist via the GUI when creating an ActiveReport or do you have to manually amend the code generated ? Regards, Ian

Ian,

At the moment, we do not use InfoAssist at our site.


Dave

No probs Dave. I will check with our customer support people.

You can turn on the Active Cache in InfoAssist via the Pages on Demand button on the format tab.

However, in the current release there is no way to set the number of lines.

In WebFOCUS 8, we have added full Active Report Customization, which includes this, styling of things like the menu, choosing menu items, security, etc.

The only thing we did not add in WF 8, is the ability to start with a calculation preset on a column.

Many thanks Matthew - works well. Look forward to seeing other 'improvements' in WF 8.