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 with the FIX attribute

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 Using tables for managing numbers

4.12 Narrowed search

4.13 File output facility for BLOB data

4.14 Addition update and partial extraction facility for BLOB and BINARY data

4.15 Retrieve first n records facility

4.16 Automatic reconnect facility

4.17 Locator facility

4.18 Facility for returning the total number of hits