Here is some example cases,

I've 1 corporate form with 1 staff table in corporate form.

Corporate trying to pay 1000 staff at once.

There is 4 state which is

Draft > Submit > Approve > Paid

While click paid button system will create res partner,  create users,  create history, and send email

1000 users now taking a long time

Now, i'm trying to speed up using SQL command, but there's i've no idea with send email.

May someone give me advise to handle this kind of data ?

SQL Create 1000 data = less than minute
.create + dictionary = 21 Minutes

Any better way than SQL ?