(2024-06-27 03:24:10) Information: Physical FileSize=1170.84 Mb. Memory Allocation Delta for this file=23.73 Mb. Available Physical Memory Before Open=249645.22 Mb. Available Physical Memory After Open=249561.25 Mb. Total Physical Memory=258047.43 Mb.
(2024-06-27 03:24:10) Information: Attempted to load the document without data.
(2024-06-27 03:24:10) Information: The document was loaded successfully.
(2024-06-27 03:24:10) Information: Document was opened successfully
(2024-06-27 03:24:10) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
(2024-06-27 03:24:10) Information: The Source Document is being reloaded. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw
(2024-06-27 03:24:10) Information: Waiting for the document log "\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw" to become available.. Check until 27/06/2024 3:24:40
(2024-06-27 03:24:10) Information: Found a document log. FileName=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw.log
(2024-06-27 11:17:39) Information: The Source Document reload complete. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw
(2024-06-27 11:17:39) Information: Memory Allocation Delta for this file=22557.20 Mb. Available Physical Memory Before Reload=249559.45 Mb. Available Physical Memory After Reload=144159.32 Mb. Total Physical Memory=144159.32 Mb.
(2024-06-27 11:17:40) Information: The Source Document was reloaded successfully.
Thank you @Rajiv-Dharia. We can't see much from the QMC Logs besides the duration and memory allocated. Your app really has at the end around 18GB? Overall tips you can try to reduce the reload time: - Only load the rows and columns that you really need - Try to bring the QVDs as ready as possible, just to load them, preferably optimized. Maybe you can do some of the heavy lifting in other QVD Builder apps running them in parallel. Your dashboard app will be just about loading the QVDs as fast as possible. - Use AutoNumber in your key fields, this can reduce the size of your app drastically
It's only the task-log with the results of the task - but not what happens within the load. Therefore take a look in the document-log which will show which single load needs how much time and how many source- and target-records it has had.
Quite clear is already from the task-log that your system has enough RAM. Further, saving the application needs around 1 minute - which could be taken as hint for possible causes, depending on the amount of data which were included.
