/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

11 votes250 views1 answer
How to get ddl for materialized view
SQL
2 votes204 views2 answers
Postgres select duplicate columns
SQL
0 vote206 views1 answer
Select sql in descending order
SQL
0 vote280 views1 answer
Sql server sleep
SQL
3 votes204 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote195 views2 answers
Mysql on update current_timestamp
SQL
0 vote280 views1 answer
Varchar2 length in oracle
SQL
0 vote215 views1 answer
Sqlite explain plan
SQL
0 vote213 views1 answer
Query only first letter string
SQL
0 vote202 views1 answer
What is delimiter in mysql
SQL