topic Re: Best Prentice in QV projects in QlikView

Best Prentice in QV projects

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to QV and started learning. i have a one question, in real time first do we create a .QVD's files and then use these files in QVW application or directly create the scripts with required tables and coulmns in .QVW. what is the general practice.

Thanks and Regards,

Saida Reddy.

Re: Best Prentice in QV projects

Miguel_Angel_Baeyens — Tue, 11 Apr 2017 15:35:02 GMT

For me, using QVDs is a must, I usually have lots of data to load, some historic data which change once per year or never, and it does not make sense to reload from the database again.

Technically speaking, you can work without QVDs and I could even think of super fast reload scenarios (near real time, although not the right use case) where the less time you use to load, the better, and depending on the size, network, disk IOPS... saving everytime to QVD (especially if you are not going to reuse them) would not even be recommended.

On the other hand, it is could also happen that it is faster to reload from a QVD than from a RESIDENT table or from the source, so you heavily rely on QVD files.

As a rule of thumb, just store any table you load to a QVD file, and load from them as often as possible.

Re: Best Prentice in QV projects

Siva_Sankar — Wed, 12 Apr 2017 02:05:42 GMT

Three Layer Architecture In Qlik | Qlik Community

Siva

Re: Best Prentice in QV projects

Wed, 12 Apr 2017 11:24:32 GMT

Thanks for your explanation. now i understand QVD files and exploring how to create and load qvd files into QVW.

Here i got one more question. we create qvd script files using qvw application. in real time when we deploy the qvd files into server do we need to deploy the qvd files and qvw files as well used to create the qvd files or only qvd is enough.

Re: Best Prentice in QV projects

ahaahaaha — Wed, 12 Apr 2017 14:46:23 GMT

HI Saida,

If you did not change the data in your database, only the created QVD files are enough, you can immediately download them into QVW applications. If the changes / addition of data were, it will be necessary to recreate the files QVD, and then already load them into QVW file of application.

Regards,

Andrey