I finally found the post that I was trying to recall in How can I speed up local backups?
Store temporary files in memory #2816 in 2017 talks about the non-seekable streams.
2014 comments probably predate Duplicati 2, but possibly some of the ideas still hold:
Attempt to avoid temp files if the backend supports streaming #181
The problem with this is handling retries, as the retry has to roll back the entire state and re-produce the volume.
This refers to unnecessary writes on SSDs where a system can write to a non-SSD location. If all you have is an SSD, you can reduce temp writes by disabling the upload asynchronously option.
–synchronous-upload is now the documented option. Anyone care to test if it will reduce writes and speed?