So far, we've seen that stored programs can offer some significant advantages.

Stored programs offer some very important advantages over more general-purpose languages, including:

The end result is a stored program that contains no error handling.

DAT-07: Create stored programs in strict mode to avoid invalid data assignments

We believe that there are three main principles of stored program optimization:

Stored programs are often slower-especiallyfor computationally expensive operations-thanequivalent middle-tier code.

To present the overall benefits of using stored programs in your applications.

The use of stored programs can lead to a more secure database.

Stored programs might be slower-especiallyfor computationally expensive operations-thanequivalent middle-tier code.

One hundred hours are available for subscribers to record and store programs.

General processing flow when calling a stored program from an external language

Furthermore, the stored program language was evolving as we constructed the book.

Use prepared statements inside of stored programs only when absolutely necessary.

In general, dynamic SQL inside of stored programs represents a significant security risk.

But you also need to consider the potential disadvantages of using stored programs:

PRG-07: Use stored programs to implement code common to multiple triggers