Report Loading taking lot of time

Some of the reports are taking lot of time to load. Our analysis is showing data fetching from the DB is pretty fast, its the report output on the browser that is taking time. In some cases Firefox browser is throwing following exception ""A script on this page may be busy, or it may have stopped responding. You can stop the script now, or you can continue to see if the script will complete."

Tried with IE8 too but its taking time there too. My report is just trying to pull 8-10 columns and numbers of records expected are approximately 15000. Please advise.

Thanks,
Rahul

On introducing pagination (Records Per Page option) in the report, its coming back fast. Is there any option in the admin console where i can specify this setting so that it is applicable to all the reports by default?

Hi Rahul,

Currently this cannot be done, I have created an enhancement request [TASK ID = 110693].

At this point I cannot give an ETA on when this will be implemented, however this will be considered for a future build.

Regards,
Steven

8-10 Columns and 15000 records in the report is not that big. I am just wondering why it is taking so much time to load. Is there anything that I can do to improve performance or pagination is the only solution. Please advise.

Rahul

Hi Rahul,

How long does the query take when running it directly against the database, and how long is it taking in Yellowfin?

Some things to take into consideration when identifying performance issues;
-Are there many users logged into Yellowfin at this point in time
-Is it the chart itself that is taking a while to generate
-Is this a cross-tab report
-Do you have analytic functions applied to the report

Also, which version & build of Yellowfin are you using?

Regards,
David