Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an unusual problem. I have one particular QlikView document that is extremely slow to save for some reason. Whether I save via ctrl-S or the save before reload function, it hangs up QlikView for several minutes.
The first thing I did was to turn compression off. The file is 3-4 times bigger now, but it had zero effect on save time, which really surprised me as that is the only thing I've previously encountered that caused an extended save time.
Also, this just isn't that much data. The main fact table is under 9 million rows, the resulting file is about 150 MB.
Finally, I have another file that contains the same data - This data model file saves in just a few seconds even with compression. The file that's causing the problems is my UI file, which simply binary-loads the data model file and has a few mapping tables. The reload happens in 4 seconds once it starts, but the save is REALLY slow.
FWIW, none of the system resources seem to be maxing out during this process - Qlikview just hangs up and is "Not Responding" for 4-5 minutes every time a save happens.
What could be causing this?
Thanks in advance for any ideas!
Some time a go, I had issues with slow QVW saving due to hidden sheets / objects:
What affects the application saving time?
Not sure if this applies to your issue, but it's worth checking.
Hi Julian,
Can you check the below link?
QV document save - not responding
Let us know, if it is working or not.
Thanks.
Sethu
Turns out the reason for mine was that I had added a deep table (~10m rows) with an inputfield... and Qlik doesn't like this! When I removed it all is fine!
Did you ever determine the issue?