Category "system-design"

Single Large Transaction VS Multiple Small Transaction

I am designing a system where users can select/ insert/update/ delete multiple rows of multiple tables multiple times (n times in a loop based on some logic, th