need to help

[#1]

Hello team

   in my report one table is getting 21 lakhs records, but once it is getting loaded report got hanged. Can any one help me what need to be done

[#2]

Hi Srinivasan,

Try saving your table into qvd and then drop it.

Again load the qvd file. It might work . But not sure.

[its_anandrjs]

You are reading the QVD file or may be direct from the source file let me know best option is QVD.

[engishfaque]

Dear Srinivasan,

QlikView Data (qvd) file is the best solution for that kind of huge records loading and performing any action over the data quikly and efficiently.

Kind regards,

Ishfaque Ahmed

[sujeetsingh]

QVD may be a option

[#6]

Team

   I am not having any qvd file, i am string loading from the load script (querying from the database itself.), there are no such option to save these data in QVD files.

[ThornOfCrowns]

Once you have loaded your data into a table, you can save that table as a QVD.

[its_anandrjs]

You have to create the QVD makers for the tables

Ex:-

SQLTable:

SQL Load

*

From <SQL Source>;

STORE SQLTable into SQLTable.qvd(qvd);

DROP TABLE SQLTable;

QVDTable:

Load

*

From SQLTable.qvd(qvd);

[#9]

While loading the Script.

Store "Table Name" into "Path".qvd' (qvd);

Drop "Table Name";

then Load from the saved qvd file in the path.

[Anonymous]

Hi Srini,

You need to do some optimization work during development.

For example,

1) You should create QVD if you have huge record set.

2) Remove unwanted columns when loading data into application.

3) Try to standardize and clean all columns in QVD creation level not in application level.

5) Simplify data modelling. Always go for star schema approach.

4) Always use Set Analysis.

Hope this helps you.