/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 vote243 views1 answer
How to show index type in postgresql
SQL
0 vote242 views1 answer
How to query without duplicate rows in sql
SQL
0 vote225 views2 answers
Mysql slave status
SQL
2 votes251 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote246 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote231 views1 answer
Oracle sql winter time change
SQL
0 vote246 views1 answer
Exectuer myssql .sql
SQL
5 votes252 views1 answer
Sql add column after another
SQL
42 votes283 views6 answers
Rename table sql server
SQL
2 votes235 views1 answer
Postgresql drop primary key constraint
SQL