issue wilth loading of data - Qlik Community

Report Inappropriate Content · ‎2010-07-12

Hi,

I am trying to load the data around 6lakhs records in the System with 1.46 GB RAM with Pentium 3 processor .

it is fine with debugging and showing the number of lines.But after that it got hanged i am not able to closed and develop the objects. Is it the issue due to the RAM Size or there could be any other issue? Please help me it is very urgent.

Regards,

JL

suniljain · ‎2010-07-12

Pls extract required field only because for 6 lakhs record , 1.46 GB RAM is enough.

Close all other application which is open .

Report Inappropriate Content · ‎2010-07-15

Thanks Sunil. Its working now but it takes more than 2 hours to load 6 lakh records in to the QVW file from 3 tables. Composit primary key is there . Is it the reason it takes that much time to load the qvw file.

suniljain · ‎2010-07-15

Dear Friend ,

Is there any complex calculation in script?. Calculation slow the execution speed.

Regards

Sunil Jain

rwunderlich · ‎2010-07-16

1.4GB is probably enough for 600k records, but it depends on the number of columns and the size of the columns. How many columns do you have and do you have any long string columns.

Another thing that can slow down the load is the generation of synthetic keys. Are you winding up with any synthetic keys in your model?

-Rob

Report Inappropriate Content · ‎2010-07-16

Thanks Bob and Sunil for your response,

There is no calculation done at the Script .But i am trying to upload the Data from 3 tables. And many columns are similar in all the three tables. Is it what refered as synthetic keys and will it slow down the the uploading of data?

Regards,

JL

sparur · ‎2010-07-16

Yes, you should rename all fields with similar names except key fields. You can use qualify/unqualify statements for this.