DBOS recently wrote a great blog post about why you should colocate your workflow data with your application data:

https://www.dbos.dev/blog/co-locating-workflow-state-with-yo...