I have an issue with a large document (around 10 million rows in total). On my PC (with 12 GM RAM 64 bit) it works fine (slowish on calculations in objects), and 100% QVD based. It takes 1 minute to load the 10 million rows of QVDs. However, on the production QlikView server, it takes one hour on this step:
I don't know what these message meant but it looks that the qv server hadn't enough cpu/ram ressources (have a look in the performance settings within the qmc and in the taskmanager) or the server pulled the data over a slow network. Then normally such qvd load is very fast.
I don't know what these message meant but it looks that the qv server hadn't enough cpu/ram ressources (have a look in the performance settings within the qmc and in the taskmanager) or the server pulled the data over a slow network. Then normally such qvd load is very fast.
Thanks Marcus, I also believe the issue was CPU usage, due to some high intensity calculations being done on objects over millions of rows (like with firstsortvalue()). My reasoning for this, is that I loaded a blank test file onto to the server with the exact same data, and it was able to load 11 million rows in 1 minute. But when done with the front-end objects, it produced that error and took 1 hour to load.
So I rebuilt the document from scratch, and optimized it such there are
