Extending INFORMIX-Universal Server: User-Defined Routines
Chapter 5: Performance Considerations
Home
Contents
Index
Master Index
New Book
Performance Considerations
In This Chapter
SPL Considerations
SPL Compilation
SPL Execution
SPL Optimization
Optimization Levels
When Optimization Occurs Automatically
Updating Statistics for a UDR
Choosing a Virtual-Processor Class
CPU Virtual-Processor Class
User-Defined Virtual-Processor Class
Defining an Extension Virtual-Processor Class
Configuring an Extension Virtual-Processor Class
Using the noyield Option
Adding and Dropping User-Defined Virtual Processors in On-Line Mode
Considerations for Parallel Execution of SPL Routines
Number of Virtual Processors (VPCLASS)
Memory Considerations
Stack-Size Considerations
Setting Stack Sizes for User-Defined Routines
Virtual-Memory Cache for Routines
System Catalog Cache
SPL Cache
I/O Considerations
Isolate System Catalogs
Balance the I/O Activities
Extending INFORMIX-Universal Server: User-Defined Routines
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
