How to update multiple entries in a single network communication?

[Charlestar]

I want to transmit a queue of triples [(status, app_name, id), updating the status of entries where app_name and id match to the current status. I want to send a batch of requests to the database server in a single network communication to speed up execution. I feel that the existing update_many method cannot meet my needs because it requires putting the update request into a single SQL statement, which seems difficult to implement. Can you give me some suggestions on how to speed things up?

[tyt2y3]

if your (id, app_name) has a unique key (which you should for this use case), you can do on conflict update.

status::Entity::insert(item)
    .on_conflict(
        OnConflict::columns([status::Column::Id, status::Column::AppName])
            .update_column(status::Column::Status)
            .to_owned()
    )

it results in something like INSERT INTO VALUES ON CONFLICT (id, app_name) DO UPDATE SET status = excluded.status