Service Group Application Reference

Service Group Application Reference

Performance Optimization

Performance Optimization

When using SSA-NAME3, the term ’Performance’ could be measured in a number of ways:
  • on-line response time
  • batch run time
  • screen paging & network load
  • SSA-NAME3 compute time & memory
  • effectiveness of the search from the user’s viewpoint
In some cases there will need to be a compromise between one or more of these and the choice should be made with a good understanding of the needs of the system and the needs of the users.
As described in the Database Design Notes section, physical optimization of your database file, index, table or buffer pool will optimize the physical I/Os, and this often forms a significant part of search performance. Following are specifically application oriented points and pitfalls that affect performance:
Improving Response Time
In applications where a match is expected, use a Positive Search strategy and always search with the most complete name data available, even if the words are suspect. If a match is not found the search can progress to lower levels.
Understand that an approach which involves sorting the candidate records or processing many records before displaying a few can adversely effect response time. The compromise is, however, that such an approach often improves the effectiveness of the search and decreases the network load.
Use a search strategy which does not involve re-reading previously read records (e.g. use an ’exclusive’ positive search strategy rather than ’inclusive’ one see the
Exclusive Search Range Processing
section).
Improving Batch Run Time
Ensure that the search is not operating at a wider level than it needs to go for the match requirements. For example, if the batch run is looking only for definite matches then use a narrower search strategy than would be used for suspect matches.
Decreasing Screen Paging & Network Load
Match and sort the candidates in order of their likeness to the search data, before displaying the results. This is called ’Ranking’ and often saves the user from the need to page through multiple screens.
Decrease the number of screens needed to make the choice by removing headings and redundant data. This may be worth some smart screen layout to handle the great variability in name and address field lengths. A fixed field approach often wastes space and can actually make the screen difficult to read. Likewise, using two lines per candidate record increases the number of screens required to present search results.
SSA-NAME3 Compute Time & Memory
SSA-NAME3 is compute-only at run-time and is fully re-entrant. In a multi-user environment try to use only one copy per address-space.

0 COMMENTS

We’d like to hear from you!