Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sjaiswal13
New Contributor II

QVD Size

HI,

What's the biggest size of QVD you are using ? Is there any limitation on the size of the QVD for the most efficient performance?

Thanks,

Sonam

4 Replies
aworrall
New Contributor

Re: QVD Size

Hi

Our biggest QVD is 1.6Gb.

For maximum efficiency have you looked into incremental loading? 

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incrementa...

Let me know if I can be of any help with that

drillnaut
Valued Contributor

Re: QVD Size

Mine is 1.8 GB, the performance is okay.  But we use Dollar General hardware, so I think it all performs pretty well in my opinion.

lcontezini
Contributor

Re: QVD Size

It depends on a lot of factors, BUT the performance is improved if you load multiple smaller qvd's instead of a big one.

sjaiswal13
New Contributor II

Re: QVD Size

I have a qvd 5 GB in size and my app is performing fine. But not sure if the data is huge like billion rows in a fact. how can the qvd size be decreased?