Presented at INSYNC 21

Session ID: 100730

Efficient applications require the best performance from all components used to implement the application. If you are using cloud services, tuning of some components is out of your control, but regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly-performant code in the first place than it is to have to fix the code later when you find that it is not performing well.

At this session, you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.