How to use the Power of the QV Server's RAM for development?

[Greg_Williams]

I need options for how to utilize the robust capabilities of the QlikView Server machine's hardware.

E.g. Customer X has a 128 GB RAM and 16 core machine...I want to take advantage of this machine's power for my development which requires me going have very large data sets. My smaller 4 GB RAM machine cannot handle the data loads. My machine is running out of memory;however, if I use the Server's machine - I will be fine.

My customer is concerned about installing the QV Desktop software on the Prod machine and doing development on the machine by permitting remote desktop.

When I have attempted to Open in Server > this only permits read only access and cannot modify the existing content on AccessPoint.

...need some suggestions, what has worked, what are my options?

Thanks.

gw

[luciancotea]

Development is done using QlikView Desktop.

1. Install QV Desktop on the server machine and work remotely.

2. Upgrade your machine to a 32GB RAM one (a little over. 1000 EUR)

[Greg_Williams]

Yes. I have heard both of those suggestions prior to my posting. I was hoping there were other techniques available. In a "secured" age, I am reluctant to suggest to my customers to remote desktop into the PROD box for development. They have one machine. Open in Server doesn't seem to be a viable option. I can suggest having them buy "near-server" new laptops but I'm looking for even more suggestions...if they exist?

Thanks for the info.

[Anonymous]

Greg

Here we have a dedicated Development server with a suitable spec and developers RDP into this Dev server to develope and it all works fine.

Could you do similar ?

[I would strongly recommend against doing any development on the Production QlikView server]

Best Regards,     Bill

[Greg_Williams]

Yes. I highly discourage the practice of development done on PROD too...but limitations in hardware cause us to do things we don't always want to do

Good suggestion. Thanks.

[MarcoWedel]

Hi Greg,

try to decrease your RAM usage on your development system using the debugger option "Limited Load":

Maybe limited row numbers are sufficient for the creation of your load script and data model.

To work on specific visualization requirements, that need the complete data, you could publish the qvw on the PROD system and use the IE plugin for browser based front end development.

regards

Marco

[SergeyMak]

To decrease amount of RAM needed for development you can use WHERE clause and load only several last months or days of data. I usually do so if I need to check issues with developed reports.

[erichshiino]

This is a good approach for development.

When you use the server for development you might consume too much power and make the machine slower for the uers.

Also, when you use less data, the reload will be faster.

[MarcoWedel]

You could also define some variable to turn the limited load on and off (i.e. time Ranges, record numbers, ID Ranges ...)

[MarcoWedel]

or use the 'sample' prefix to load only a fraction of your data as described here:

How to select random records to load into qvw?

regards

Marco