/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 vote132 views1 answer
Search column name sql
SQL
0 vote130 views1 answer
Fast sql column count
SQL
16 votes119 views1 answer
Mysql reset auto increment value
SQL
0 vote127 views1 answer
Product of a column in mysql
SQL
1 vote132 views1 answer
Mysql check table exists
SQL
-1 vote212 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
2 votes130 views1 answer
Sql update \
SQL
1 vote80 views1 answer
Insert into sql
SQL
1 vote159 views1 answer
Print year of a date sql
SQL
0 vote183 views1 answer
How to compile a function in oracle
SQL