Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please tell me how to reduce the below Loading time in QMC
(2017-01-13 15:56:07) Information: Loading. LoadTime=00:00:01.0140260
(2017-01-13 15:56:09) Information: Loading. LoadTime=00:00:03.0420780
(2017-01-13 15:56:13) Information: Loading. LoadTime=00:00:07.0981820
(2017-01-13 15:56:21) Information: Loading. LoadTime=00:00:15.2103900
(2017-01-13 15:56:37) Information: Loading. LoadTime=00:00:31.4348060
(2017-01-13 15:57:09) Information: Loading. LoadTime=00:01:03.8836380
(2017-01-13 15:58:10) Information: Loading. LoadTime=00:02:04.7251980
(2017-01-13 15:59:11) Information: Loading. LoadTime=00:03:05.5667580
(2017-01-13 16:00:12) Information: Loading. LoadTime=00:04:06.4083180
(2017-01-13 16:01:13) Information: Loading. LoadTime=00:05:07.2498780
(2017-01-13 16:02:14) Information: Loading. LoadTime=00:06:08.0914380
(2017-01-13 16:03:15) Information: Loading. LoadTime=00:07:08.9329980
(2017-01-13 16:04:15) Information: Loading. LoadTime=00:08:09.7745580
(2017-01-13 16:05:16) Information: Loading. LoadTime=00:09:10.6161180
(2017-01-13 16:06:17) Information: Loading. LoadTime=00:10:11.4576780
Thanks,
Lawrance. a
Hi Sommer,
Could you please explain how to resolve this problem, if any other solution
Thanks,
Lawrance A
I recommend you start by taking a look at the Document log to see where is the script the time is spent.
-Rob
I checked the Document Log there is no delay. Reload time takes only 5 minutes but distribution takes more time. Please find the attached screenshot for your reference.
Thanks,
Lawrance A
My datamodel qvf file size is 3.5 GB and my dashboard loading time is 7 minutes. please help how can I reduce the datamodel loading time.
I used the aggr() with a date range in the set expression it is required.
and also distinct count.
There might be no easy way ... else it could mean that a re-design of the application would be needed to develop the application in the direction of a star-scheme (only a single fact-table + n dimension-tables) and avoiding if-loop and aggr() within the UI.
- Marcus