Stored procedures are more effective 💪 and resource-efficient than SQL queries sent to the relational database management system (RDBMS) by the application server. There are two reasons for that:
1️⃣ - a stored procedure saves the server from interpreting the query as it is pre-compiled ⚙️
2️⃣ - a stored procedure uses less bandwidth 🌐 as there is less information transferred between the server and the client
You should therefore utilize this RDBMS function as much as possible.🙌
All recent RDBMS (SQL Server, MySQL, PostgreSQL, etc.) support stored procedures.
When should I use stored procedures?
- To avoid sending complex queries to the SQL server, which are analyzed for syntax and then interpreted before being run. These steps use up many resources 👎.
- To simplify the website’s code and thus improve maintainability. A website’s ecological 🌍💚 footprint also includes the resources used to maintain and upgrade it.
#greenIT #developer #storedProcedure