Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
MVP
MVP

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

What is "Crores" ?

Highlighted
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.