Time to Load Data

[farolito20]

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?

[#2]

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.