/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 vote133 views1 answer
Add plugins to mysql workbench
SQL
0 vote133 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote145 views1 answer
Sqlite higher or equal
SQL
0 vote140 views1 answer
Postgres drop type
SQL
0 vote202 views1 answer
SQL query to verify the size of the table
SQL
-1 vote91 views2 answers
Datetime sql server week
SQL
0 vote136 views1 answer
Lost connection to mysql
SQL
0 vote146 views1 answer
Create column that already exists mysql
SQL
10 votes146 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote139 views1 answer
T sql cursor tr
SQL