DracoBlue I'm sorry, but I don't understand what you mean by: "optimizing the database is a tragedy"?
Did you add this into you Database Directives? Enhance >> Settings >> Services
Directive : sql_mode
Value : Text
Text* : NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES