Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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.
alex_stone
Contributor

How to update big data?

Currently, we have big data table, it contains more than ten millions records. The transaction log will full when we update the data, and then the database will on hold. We update the data split into a lot of part based on row id. We update 5000 records one time. But the transaction will full also.

Is there any other solution to solve this problem?

Tags (1)
4 Replies
oknotsen
Honored Contributor III

Re: How to update big data?

You sound like you are talking about updating some database system, not like you are using QlikView.

What is it that you are exactly doing or trying to do?

10 million records is a day at the beach for QlikView.

May you live in interesting times!

Re: How to update big data?

Perhaps you're looking for incremental loading: Dynamic Update and Incremental Loading


talk is cheap, supply exceeds demand
MVP
MVP

Re: How to update big data?

Can you provide us with your load script or a part of it? How are you trying to update?

alex_stone
Contributor

Re: How to update big data?

Thank you for your reply, I add checkpoint statement in sql script, and the problem solved.

Community Browser