Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

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

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

Not applicable

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

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.

Community Browser