Reloading through QV Server(QMC) took too much time!!

[surendraj]

Hello Guys,

When i am manually running a Application(.Qvw) on server its taking only 15 mins to complete, but i am reloading the task on the same qvw on QMC its taking 5 hours to run.

I tried multiple alternatives to resolve this..But no luck!!

Please help me on this..

By the way  QVW is pointing to SQL SERVER to fetch the tables.

Thanks in Advance!!

--Surendra

hic‌

sunny‌

@Tresesco B

@swuehl

[swuehl]

Have you enabled and checked the document logs in both scenarios to see which script part takes the time?

[surendraj]

Thank you Stefan for quick response.

Yes..while fetching the data from Sql server it taking long time.

I have verified the dashboards for the long running issues and found a common error that all the dashboards are taking long time when trying to extract the data from the database.

Even when I checked with the Database team heard that the tables used in this dashboards is not getting inserted/updated during our job runs.so this might not be an issue.