Scalability is about application, architecture and infrastructure
design, and careful management of server components.
1. Object Relational Mappers
ORMs are popular among developers but not among performance
experts. Why is that? Primarily these two engineers
experience a web application from entirely different
perspectives. One is building functionality, delivering
features, and results are measured on fitting business
requirements. Performance and scalability are often low
priorities at this stage. ORMs allow developers to be much
more productive, abstracting away the SQL difficulties of
interacting with the backend datastore, and allowing them to
concentrate on building the features and functionality.
On the performance side the picture is a bit different. By
leaving SQL query writing to an ORM, you are faced with complex
queries that the database cannot optimize …[Read more]