/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 votes119 views3 answers
How do I add a user to a postgres database? cli
SQL
10 votes56 views2 answers
Django mysql
SQL
6 votes116 views3 answers
What is where in sql
SQL
1 vote119 views1 answer
Oracle sql pad left zeros
SQL
0 vote106 views1 answer
Generate sequence number in sql server
SQL
2 votes95 views2 answers
Oracle create table if not exists
SQL
0 vote115 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote107 views1 answer
Sql query for select from specific columns in a table
SQL
14 votes100 views2 answers
Oracle add column with default value
SQL
14 votes146 views1 answer
How to export db from mysql
SQL