/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

1 vote265 views1 answer
Stored procedure return value
SQL
0 vote287 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote340 views1 answer
Postgres list all triggers
SQL
0 vote304 views1 answer
Alter check command
SQL
0 vote297 views1 answer
Execut sql python
SQL
10 votes289 views1 answer
Create table oracle
SQL
0 vote298 views1 answer
Mysql terminal run sql file
SQL
0 vote309 views1 answer
Oracle drop type
SQL
0 vote293 views1 answer
Mysql join same table multiple times group by
SQL
0 vote305 views1 answer
Where to find pg_hba.conf in ubuntu
SQL