All geek questions in one place

MySQL performance: raw query and stored procedure

As I know, there is a significant performance difference between raw queries and stored procedures in MSSQL (for example, query plans are cached the same way for both). But what about MySQL?

+3
source share
1 answer

Firstly, the value in SP is not in performance; there hasn't been a while. The value of stored procedures is more related to the security and longevity of data. Take a look at an article here a couple of years ago - Is this a legitimate advantage of using embedded SQL over stored procedures?

+4
source

Source: https://habr.com/ru/post/1787225/

More articles:


All Articles