Using ORMs is convenient, but nothing beats understanding the actual SQL queries your database is running under the hood.
To make them more efficient, you can use the tools the database engine provides. Two of my favorites are generated columns and table views.
In this article I wrote for Tighten we explore how they can help you build faster applications and review a practical example with an 80% speed boost in query time.
Check it out!
