Fully agree! Bad code eliminates power of servers. Specially when all queries come to one database without any help from replication, cluster, loadbalancing and other smart words in the area.
This is similar to increasing memory for solving memory lick - increasing memory will never help against memory lick.