topic Re: QVD DES in QlikView

QVD DES

Mon, 23 Mar 2015 04:59:36 GMT

4) minmum how many records are inserted in qvd?

Re: QVD DES

amit_saini — Mon, 23 Mar 2015 05:10:43 GMT

Suman,

You can fetch n records from the DB and create QVD.

Thanks,
AS

Re: QVD DES

jonathandienst — Mon, 23 Mar 2015 05:12:10 GMT

You can create a QVD with zero records. The file will still contain the metadata, but nothing after the metadata.

HTH

Jonathan

Re: QVD DES

amit_saini — Mon, 23 Mar 2015 05:15:30 GMT

You can create qvd even though if you are having no records .

Thanks,
AS

Re: QVD DES

Mon, 23 Mar 2015 05:19:31 GMT

max records into qvd?

Re: QVD DES

amit_saini — Mon, 23 Mar 2015 05:21:50 GMT

depends upon your system RAM.

Thanks,

Re: QVD DES

jonathandienst — Mon, 23 Mar 2015 05:39:30 GMT

I am not aware of any effective hard limits, but the file size and memory requirements are practical limits. If your data set is large, you may get a more reliable solution by partitioning the data - for example one QVD per month with 1m records, rather than a single QVD containing 60m rows for the last 5 years.

When following optimisation suggestions, always remember YMMV