Some of the best practices, I know and would like to share with fellow QVS administrators are :.
- 1) Never copy qvw into root folder cos it contains pgo files ,they are like configuration files.
- 2) Everything on mounted folder.
- 3) Always create task groups, this will avoid confusion when you have huge number of tasks
- 6) Minimize the use of input fields.
- 7) Not a good practice to let the users add objects via access point uses up memory.
- 8) Not a good practice to let users download documents ( bandwidth usage)
- 9) Limit the number of rows in export ie if a table has 60 million rows and users exports them..ie 60 million not good, limit it to 1000 or something.
- 10) The share collaboration feature eats resources.
- 11) Put all the source qvd,include files and images in source document, maintain 1 source for 1 qvw and place qvw on the user document.
- 12) When you delete a qvw delete all tasks associated with it and free all the document cals associated with it.
- 13) QVS detector
- 14) QVPT
- 15) In qvs 11 you can do extraction from the server itself, meaning you don’t have to create a separate extraction qvw .
Although some of them are best practices for developers, I shouldn't agree with many of the points you list above, depending on what the user is expecting from the tool.
Downloading is not a best practice. Ot because bandwidth, but mainly because the cost and time of installing and configuring QlikView Desktop in each computer.
Sharing objects will use a small amount of disk and memory, but it can provide users with a powerful tool to build their own analyses.
It's always best practice to have QVW to control what you extract and create tasks from those files.
Source/User documents is used by Publisher, it distributes if you set up a task to do so.
If you have a chart displaying 60 million rows, I'd say that something is wrong in the model or analysis (I mean, you really need 60 million rows in one chart? There is no way to analyze that!)
I'd recommend you to go to the QlikView site, training, and follow the several free documents and videos you have.
Hope that makes sense.