Oracle PL/SQL e: Advantages of PLSQL-HIGH PERFORMANCE-3
istudentindia.com
2016-01-17
Views 10
HIGH PERFORMANCE
1) With PL/SQL, an entire block of statements can be sent to the database at one time. This can drastically reduce network traffic between the database and an application.
2) You can use PL/SQL blocks and subprograms (procedures and functions) to group SQL statements before sending them to the database for execution.
3) PL/SQL also has language features to further speed up SQL statements that are issued inside a loop. PL/SQL stored subprograms are compiled once and stored in executable form, so subprogram calls are efficient.
4) Because stored subprograms execute in the database server, a single call over the network can start a large job. This division of work reduces network traffic and improves response times. Stored subprograms are cached and shared among users, which lowers memory requirements and call overhead.
1) With PL/SQL, an entire block of statements can be sent to the database at one time. This can drastically reduce network traffic between the database and an application.
2) You can use PL/SQL blocks and subprograms (procedures and functions) to group SQL statements before sending them to the database for execution.
3) PL/SQL also has language features to further speed up SQL statements that are issued inside a loop. PL/SQL stored subprograms are compiled once and stored in executable form, so subprogram calls are efficient.
4) Because stored subprograms execute in the database server, a single call over the network can start a large job. This division of work reduces network traffic and improves response times. Stored subprograms are cached and shared among users, which lowers memory requirements and call overhead.
Report form
RELATED VIDEOS
