/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 vote64 views2 answers
Procedure pl/sql
SQL
0 vote114 views1 answer
What logs are available on RDS MySQL?
SQL
5 votes101 views2 answers
Get columns number sql
SQL
0 vote123 views1 answer
How to change mysql port in xampp
SQL
1 vote103 views1 answer
Rails run native ssql query
SQL
4 votes103 views1 answer
Oracle show errors
SQL
7 votes105 views2 answers
Mysql get year from date
SQL
0 vote123 views1 answer
Declaring variables in pl sql
SQL
0 vote97 views2 answers
Find Overlapping sql
SQL
1 vote101 views2 answers
How to enable error squiggles in vs code
SQL