Although ORMs make SQL simpler and save development time, the use of ORMs makes sense for applications running against databases with small datasets, or to perform rapid prototyping. It can be usually challenging to manage ORM when the database grows in size. The drawbacks of ORM can be summarised as the following:
- there will be a slight learning curve to using the ORM toolset efficiently
- performance degradation on complex SQL queries
- ORMs are generally slower than using SQL due to abstraction
Thanks for the insightful post!
Although ORMs make SQL simpler and save development time, the use of ORMs makes sense for applications running against databases with small datasets, or to perform rapid prototyping. It can be usually challenging to manage ORM when the database grows in size. The drawbacks of ORM can be summarised as the following:
- there will be a slight learning curve to using the ORM toolset efficiently
- performance degradation on complex SQL queries
- ORMs are generally slower than using SQL due to abstraction