Report taking longer time to refresh

Syed Rahman shared this question 1 year ago
Answered

Hi Experts,

I have a report which is taking a bit longer time to refresh. I have optimized the query at MYSQL level (query refreshes in 10 sec) but when I run the same report on YF, it takes round about 25 seconds.

The report returns almost 2 million records in total. I thought of doing cached filters but then it has too many filter values.

Could you please assist me on different ways where I can optimize the report at YF level.

Regards,

Syed

Comments (8)

photo
1

Hi,

Any updates on above.?

Regards,

Syed

photo
1

Hi Syed,

Can you please run the info_thread collector for the duration of this report load process?

https://community.yellowfinbi.com/knowledge-base/article/infothreadrunner

This should tell us exactly what Yellowfin is working on at the time.

Regards,

Nathan

photo
1

Hi Nathan,

Thanks for looking into this.

I am attaching info thread collector logs.

Regards,

Syed

photo
1

Hi Syed,

Unfortunately for a quick fix, there is nothing that really jumps out at me here. There are several different processes occurring but all of them are pretty standard and none are taking too long.

  • Is this a stored procedure view?
  • Do you have any related reports?
  • Does this report have a refresh schedule on it?
  • Is this a cross-tab?
  • What is your JVM usage like during this loading?

Regards,

Nathan

photo
1

Hi Nathan,

Here are the answers for your questions-

  • Is this a stored procedure view? - No, we haven't used stored procedure in our views as we need filters with drop-down list. As an alternative we have saved complex query result in a table and added simple select query in all views.
  • Do you have any related reports? - Yes
  • Does this report have a refresh schedule on it? - No
  • Is this a cross-tab? - Yes
  • What is your JVM usage like during this loading? - No

Regards,

Syed

photo
1

Hi Nathan,

Any suggestions or solution for above answers.

Regards,

Syed

photo
photo
1

Hi Syed,

Sorry for the delay here. It sounds like it might be easier to just hop on a quick screen-share. Do you have time at any point early next week?

Let me know what works for you, I am on US MST.

Nathan

photo
1

Hi Syed,

I am going to set this to closed, but if you are interested in screen-sharing please let me know and it will be reopened.

Nathan