Optimization on bigger databases

So today i’ve encountered same problem again, with bigger database, when there’s more than few custom fields it’s always either killing the server, 504 or simply it won’t finish the task.

It’s okay-ish if i switch off orphans from cleaning, but that’s the main reason i would like to run optimization in the first place for some cases.

Any idea how should i with that?