Category: Development

SQL, React/Redux/Mobx, TypeScript, Unity3D, Architecture

Stored procedures are faster than queries?

In some companies including leading ones stored procedures are labeled as bad practice and banned forever, in others they are praised for better performance. Let’s take a closer look into it. Caching the execution plan Let’s start from the performance perspective. Whenever you submit a query to the database system, it will need to create a query execution plan. This is an ordered set of step, which tells the database how to get your data. Every query requires a query plan before it is actually executed. Since there are different way how to get there, the DB will...