How to update big data?

[alex_stone]

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?

[oknotsen]

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.

[Gysbert_Wassenaar]

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

[petter]

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

[alex_stone]

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