Multiple DB update by diesel-async

[MarryP0ppins]

I am trying to speed up my function with diesel DB update.

pub async fn multiple_update_answers(
    connection: &mut AsyncPgConnection,
    answer_info: Vec<UpdateAnswer>,
) -> Result<Vec<Answer>, Error> {
    let mut _answers: Vec<Answer> = vec![];

    for answer_raw in answer_info.into_iter() {
        match update(answers.find(answer_raw.id))
            .set::<UpdateAnswer>(answer_raw)
            .get_result::<Answer>(connection)
            .await
        {
            Ok(result) => _answers.push(result),
            Err(err) => return Err(err),
        }
    }
    Ok(_answers)
}

I'm tried using thread::span and task::span with Arc::new(Mutex::new(connection)) but probably doing something wrong because it doesn't work.

Is there any way to do it? And is it even possible?

File with function: answer.rs