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!
