/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

2 votes317 views1 answer
Mysql auto increment jumping
SQL
0 vote338 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote347 views1 answer
How to fetch unique records from two tables
SQL
2 votes300 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes365 views2 answers
How to create an empty table from an existing table
SQL
0 vote342 views1 answer
Postgres data location
SQL
1 vote330 views1 answer
Mysql show data from table
SQL
-2 votes369 views1 answer
How-to-remove-mysql-root-password
SQL
5 votes343 views2 answers
Oracle rename table
SQL
0 vote343 views1 answer
Declare date variable sql
SQL