Delayed durability for reporting database
My question is that will changing the setting to delayed durability have an effect on the speed of the SP?

If the stored procedure makes many small updates without a transaction then delayed durability might speed it up.  But batching the inserts into a larger transaction would be a better idea.