Use external routines - improve performance of application, PL-SQL Programming

Use External Routines

The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is very efficient at the machine-precision calculations.

The PL/SQL extends the functionality of the Oracle server by providing an interface for calling routines written in other languages. The Standard libraries by now written and available in other languages can be called from the PL/SQL programs. These promote reusability, efficiency, & modularity.

To speed up execution, you can rewrite the computation-bound programs in C. In calculation, you can move these programs from client to server, where they will execute more rapidly thanks to less across-network communication and more computing power.

For illustration, you can write methods for an image object type in C, store them in a DLL (dynamic link library), register the library with the PL/SQL, and then call it from your applications. At run time, the library load dynamically and, for safety, runs in an individual address space.

Posted Date: 10/5/2012 4:57:31 AM | Location : United States







Related Discussions:- Use external routines - improve performance of application, Assignment Help, Ask Question on Use external routines - improve performance of application, Get Answer, Expert's Help, Use external routines - improve performance of application Discussions

Write discussion on Use external routines - improve performance of application
Your posts are moderated
Related Questions
Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not