/SQL/Disadvantages of stored procedures sql

Disadvantages of stored procedures sql

Advantages of stored procedures sql

A Stored Procedure can be used as a 
modular programming which means create once, 
store and call for several times whenever
it is required. This supports faster execution.
It also reduces network traffic and
provides better security to the data.

Disadvantages of stored procedures sql

Disadvantage:
The only disadvantage of Stored Procedure 
is that it can be executed only in the
database and utilizes more memory in 
the database server.

Similar codes

0 vote192 views1 answer
Group_concat only returns one row
SQL
21 votes196 views6 answers
Docker run mysql
SQL
4 votes206 views2 answers
REST API
SQL
0 vote196 views2 answers
How to count codition
SQL
6 votes192 views1 answer
Oracle trigger after connect
SQL
0 vote190 views1 answer
Codeigniter dbforge add index
SQL
0 vote252 views2 answers
Wordpress change url in database
SQL
2 votes230 views2 answers
How to check data type in sql server
SQL
4 votes186 views2 answers
Tsql utf to local time
SQL
3 votes226 views1 answer
Apex set debug level
SQL