Large amounts of update or delete optimization ?

[khanakia]

I have a use case where we fetch lots of data from Google Adwords let say Campaigns and save to the campaigns table.

But I want resync the same data once a day so what I want is, if the record exists then update if not then insert.

What is the best practice for this use case?

• Method 1: Delete all the data for a user by user_id column and batch insert again all the data?
• Method 2: Check the record if exists then send async update if not then send async insert?

Or is there any other method or best way so I can keep my clickhouse optimized while performing such operations ?

[khanakia]

@den-crane do you have some suggestions?

[den-crane]

The only solution is ReplacingMergeTree, everything else is a garbage.