Stored Procedures in Database
What are stored procedures? How is it useful?
✍: FYICENTER.com
A stored procedure is a set of statements/commands which reside in the database. The stored procedure is pre-compiled and saves the database the effort of parsing and compiling sql statements everytime a query is run. Each database has its own stored procedure language, usually a variant of C with a SQL preproceesor. Newer versions of database servers support writing stored procedures in Java and Perl too. Before the advent of 3-tier/n-tier architecture it was pretty common for stored procs to implement the business logic( A lot of systems still do it). The biggest advantage is of course speed. Also certain kind of data manipulations are not achieved in SQL. Stored procs provide a mechanism to do these manipulations. Stored procs are also useful when you want to do Batch updates/exports/houseKeeping kind of stuff on the db. The overhead of a JDBC Connection may be significant in these cases.
2007-04-03, 5196👍, 0💬
Related Topics:
JComponent and Component
Why does JComponent have add() and remove() methods but Component does not? Because JComponent is a subclass of Container, and can contain other components and jcomponents. 2007-04-03, 5792👍, 0💬
Creating TCP Socket
What information is needed to create a TCP Socket? The Local Systems IP Address and Port Number. And the Remote System's IP Address and Port Number. 2007-04-03, 5756👍, 0💬