4. UAP Design for Improving Performance and Handling

This chapter describes issues that UAP designers should consider to improve UAP performance and usability.

This chapter contains the following sections:

Organization of this chapter

4.1 Using indexes

4.2 Manipulation of tables

4.3 Stored procedures and stored functions

4.4 Triggers

4.5 SQL optimization

4.6 Data guarantee levels

4.7 Block transfer facility

4.8 Facilities using arrays

4.9 Rapid grouping facility

4.10 Multi-connection facility

4.11 Narrowed search

4.12 File output facility for BLOB data

4.13 Partial update and retrieval of BLOB and BINARY data

4.14 Retrieve first n records facility

4.15 Automatic reconnect facility

4.16 Locator facility

4.17 Facility for returning the total number of hits

4.18 Retrieval, updating, or deletion with an RDAREA name specified

4.19 Automatic numbering facility