yo, guys. is there some performance nerds?
I wonder if you have any stories about things that might not seem so critical at first glance, but actually provide significant benefits.
Don't run transactions in loops. Definitely not in nested loops.
Build the query and chunk it