topic Re: Continuous Reload on QVD in QlikView

Continuous Reload on QVD

sifatnabil — Tue, 26 Jan 2016 13:12:21 GMT

Hi all,

I know continuous reload on big data sets can cause issues, but how about if the qvw just continuously reloads a QVD that is approximately 5k rows max? Would it cause any issues?

Re: Continuous Reload on QVD

swuehl — Tue, 26 Jan 2016 13:28:18 GMT

This QVD needs to be updated from time to time (otherwise a continuous reload wouldn't make much sense).

You need to take care that the QVD reader / writer processes don't lock each other, which will probably result in a script error.

Re: Continuous Reload on QVD

sifatnabil — Tue, 26 Jan 2016 13:31:13 GMT

Thanks - how do I ensure they don't lock each other though? One qvw will be writing to the QVD, and the other one reading from it.

Also, do you see any performance issues with this? Thanks.

Re: Continuous Reload on QVD

Anonymous — Tue, 26 Jan 2016 13:43:09 GMT

Is the QVD used by anything else ?

If not. then why not eliminate the QVD generator & QVD and simply load the dashboard QVD directly from the data source ?

I'd also suggest putting at Sleep(10000), or whatever value you want, in the script to prevent your data source being continuously stressed.

Re: Continuous Reload on QVD

Peter_Cammaert — Tue, 26 Jan 2016 14:37:00 GMT

But one Reload Engine will be allocated for good.