Time to Load Data

farolito20 — Tue, 08 Jan 2013 21:31:59 GMT

I need your help

I hope you answer me.

I am running query from SQL tables and stored them in a QVD.

If I do this directly in sql , the query takes me 5 seconds exactly and are around 21000 rows and QlikView this expands as 1 minute. Why happen that?

Another thing, if I load the QVD, I consume all the physical memory of the computer, (8GB RAM), emains unanswered QlikView and computer beats me, having to restart, and the information is not even the 1MB . Any way to fix this?

Re: Time to Load Data

Tue, 08 Jan 2013 22:15:27 GMT

Hi,

Have you checked for any Synthetic Keys in the script?

You can see this from the Table Viewer.

Formation of synthetic keys in the script generally increases the reload time.

Regards,

-Khaled.

topic Time to Load Data in QlikView

Time to Load Data

Re: Time to Load Data