Hi,

I'm generating a report (having 10K rows) using AHTML that takes close to 8 mins, while generating the same report in other formats (Excel/HTML) takes less than 30 secs. Can any one explain why this happens, and solution(s) for it?

Thanks!

This message has been edited. Last edited by: Kerry,

Kev,

AHTML has to write all of the data to the displayed page. Try reducing the number of rows selected as a test and see if the performance improves.

Also could you please update your profile signature with your product suite, release, and platform? Thanks. It makes it easier to help you out if we have that information.

Ginny,

I tried reducing it to 500 and 3K rows, and it takes less than 40 secs both times, so I guess with increase in number of records from that point on, it goes off exponential.
So what do I do now?

Thanks!

See this...

http://forums.informationbuild...?r=31110736#31110736

Thanks, Rick!

I tried to Active Cache option by setting CACHELINES to 1000 and LINES-PER-PAGE to 200 - but didn't help. Anything I might have missed?

Thanks

Hello,

As I mentioned earlier, I tried setting
CACHELINES to 1000
AND
LINES-PER-PAGE to 200
but it still takes forever to load.
Am I missing anything here?
FYI: Number of records are 10000.

Thanks!

Did you click on the link RickW provided? The answers/ Active reports "LIMITATIONS" are there..

Hi Tom,
Yes, I did, and in that post itself someone recommended trying Active Cache Option. So I looked in the Documentation, and it says:
"To create answer sets in excess of 5,000 records, 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."
So I tried using it as in my post above, but to no avail. So my question is am I not using it right?

Thanks!

Have you set the WEBVIEWER??? Also, please review the TIP at the bottom of the page...

Active Reports Cache

Hi Tom,

Yes, I did. I've
SET LINES = 100
ON TABLE SET WEBVIEWER ON
ON TABLE SET CACHELINES 1000
Does this look alright?

Thanks!

Kev,

Yes, your code is correct.

Active reports has limitations. It is built as a stand-alone application. Here is documentation:

Using an HTML Active Report

If it is not functioning the way you feel it should, open a case with IBI.

Tom