Honestly any db system is going to be at the mercy of inefficient queries. Regardless of what one uses, optimization will always be necessary