topic Re: what process happens in the background when I run a code to load data from a table and store into QVD in QlikView

what process happens in the background when I run a code to load data from a table and store into QVD

sonikajain — Wed, 21 Jan 2015 09:06:17 GMT

Hi All,

Pleas help me understand the process - memory+CPU that happens in the bckground when I run a code that loads data from a table and stores into QVD.

Like :

TABLE:

SQL

SELECT * FROM SCHEMA.TABLE;

STORE TABLE into QVD1.qvd;

DROP table TABLE;

How does the memory required vary when data is loaded from TABLE to memory in QVW and written to QVD

Re: what process happens in the background when I run a code to load data from a table and store into QVD

Anonymous — Wed, 21 Jan 2015 09:16:40 GMT

Hi,

If u stored in a table in a QVD then the volume of the table is reduced but not the data ,

QVD are flexible to load data easily in qlikview and run very fast & gives the desired result as soon as possible compare to tables & databases connection......

Re: what process happens in the background when I run a code to load data from a table and store into QVD

avinashelite — Wed, 21 Jan 2015 09:31:21 GMT

Hi Sonika,

Qlikview is a in memory tool, so while dealing with large data we make use of this QVD.

Process:

TABLE:

SQL

SELECT * FROM SCHEMA.TABLE;

This script will import the data from the DB and store it inside the Qlikview with 10x compression.

STORE TABLE into QVD1.qvd; this will store the data inside the Qlikview to Qlikview readable format file called QVD it will be compressed and optimized.

DROP table TABLE; this will delete the data, which is inside the Qlikview application and frees the memory

Re: what process happens in the background when I run a code to load data from a table and store into QVD

Gysbert_Wassenaar — Wed, 21 Jan 2015 09:42:49 GMT

Did you try monitoring the ram and cpu usage of your workstation or server while reloading a qlikview document with that bit of script? Try asking a local friendly system administrator if you need help with that.

Re: what process happens in the background when I run a code to load data from a table and store into QVD

sonikajain — Wed, 21 Jan 2015 10:26:17 GMT

yeah, but I am looking for what happens in terms of memory and Processer usage when these statements are executed

Re: what process happens in the background when I run a code to load data from a table and store into QVD

sonikajain — Wed, 21 Jan 2015 10:26:40 GMT

I know what these statements accomplish,

but I am looking for what happens in terms of memory and Processer usage when these statements are executed