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.
balasundaram
Contributor II

Huge data issue in Qlikview?????

Hi All,

I have to extract One Fact Table from Database to QVD.

Fact Table having more than 200 Crores(2 billion rows) Rows Data.

to reduce extraction time i have splitted based on Year wise.

I am using individual QVD generators for Year wise QVDs. Even  its taking morethan 3 hours time to complete reload.

any one suggest how to reduce reload time?

Note:  Full Load only..Not possible to Implement Incremental Load

Regards,

Bala

2 Replies
MVP
MVP

Re: Huge data issue in Qlikview?????

What is "Crores" ?

MVP
MVP

Re: Huge data issue in Qlikview?????

You might have a look at this post: How qlikview can handle a billions of records?

I guess that 200 Crores is 2 billion rows right?

3 hours is not really a whole lot of time for 2 billion rows - but that depends a lot on your hardware and infrastructure.

Community Browser