Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Extraction of data into qvd takes too much of time

Hi All,

           I am extracting (loading) roughly 30 million records into qvd. To extract this data it is taking almost 6 hrs !!. Previously 2.5 - 2.8  million records used to get extracted within 1-2 hrs flat. There is no change in the schema and the script except that the records are more and the database is now moved to DMZ.

It will be of great help if I get to know how ca I improve upon the performance.

Thanks,

1 Reply
MVP
MVP

Extraction of data into qvd takes too much of time

Hi,

this could be a firewall issue..

- Ralf

Community Browser