@sanjay you are right. We have already shifted to hash key as autoname for gl entry and stock entry tables in our setup.
Please read Frappe - Performance - Naming Series
Also read [Performance] 1 Sales Invoice Save makes ~700+ DB calls. ~1000+ DB calls on Submit
For other optimisation done recently