/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 vote298 views1 answer
Mysql f# examples
SQL
0 vote301 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote285 views3 answers
String to int mysql
SQL
0 vote287 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote310 views1 answer
Sql count total by foreign key
SQL
-1 vote266 views1 answer
Mysql if example
SQL
0 vote343 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote310 views2 answers
Search stored procedures by name
SQL
17 votes366 views4 answers
Show all tables in oracle
SQL
0 vote295 views1 answer
Opensuse start MySQL
SQL