Database - SQL for Database Construction - Discussion
Discussion Forum : SQL for Database Construction - General Questions (Q.No. 12)
12.
What is not an advantage of stored procedures?
Discussion:
9 comments Page 1 of 1.
Rishi said:
8 years ago
A stored procedure is nothing but a group of SQL statements compiled into a single execution plan.
Create once time and call it n number of times.
It reduces the network traffic.
Create once time and call it n number of times.
It reduces the network traffic.
(1)
Ravi said:
1 decade ago
Please explain how store procedure will increase the network traffic?
Bhavna said:
1 decade ago
How to increase network traffic in stored procedure?
Rani said:
1 decade ago
According to me all data stored in stored procedure. And that time when search the data it may be confused.
Rohini said:
9 years ago
A major advantage of stored procedures is that they can run directly within the database engine.
In a production system, this typically means that the procedures run entirely on a specialized database server, which has direct access to the data being accessed.
The benefit here is that network communication costs can be avoided completely. This becomes more important for complex series of SQL statements.
In a production system, this typically means that the procedures run entirely on a specialized database server, which has direct access to the data being accessed.
The benefit here is that network communication costs can be avoided completely. This becomes more important for complex series of SQL statements.
Ram said:
9 years ago
First of all, what is meant by a stored procedure?
John said:
9 years ago
I don't understand why it is increase network traffic, can anyone explain more?
Debasish said:
8 years ago
Stored procedure means it is stored in the database.
Asds said:
8 years ago
Right @Rishi.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers