/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 vote180 views1 answer
Select if then postgresql
SQL
28 votes145 views6 answers
Distinct sql
SQL
1 vote182 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote223 views1 answer
Mysql 3 months ago
SQL
0 vote212 views1 answer
Database db connection string format
SQL
0 vote189 views1 answer
Mysql workbench procedure
SQL
3 votes190 views3 answers
Mysql order by list
SQL
2 votes228 views1 answer
Tcl in sql
SQL
1 vote307 views2 answers
Postgres select from last 3 months
SQL
1 vote175 views1 answer
Postgres get timestamp
SQL