How not to structure database-backed web apps: performance bugs in the wild
ORMs are really only useful for throwaway projects and beginners. I have yet to see one without serious downsides in both performance and speed of development, something that they are touted to improve but actually make worse. The ORM I&#x27;m stuck with now (Doctrine2) adds a 10x overhead to queries. For the most part, we don&#x27;t even bother optimizing queries in such situations because why waste time on something that could at most improve performance by 1&#x2F;10th? The real fix is to get rid of the ORM. That requires a rewrite of two apps that have been in development for four years each. I can&#x27;t think of a worse architectural decision for business (CRUD) software than using an ORM. Irreversible and forever fucked.