Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load a large amount of data without memory issue?

Hi all,

i need to load, in a qvd, a large amount of data from an xml file. I talk about 2 millions of record to analize.

i created a gateway page that Qlikview call instead of the full xml. This page, try to get all data in streaming mode. I used a loop with response.write that write 100 records at once.

Qlikview wait to load all the records before show the result. This take too much time for every reload. Is there a faster method to load this amount of data, like a streaming mode?

Thanks in advance and sorry for my bad english.

Angelo

2 Replies
Not applicable
Author

I forgot to say that i get the xml file from url.

Not applicable
Author

Download the XML on your local hard disk using a vb function called from the load script and let QV load it itself without other additional steps, regards.