Optimization Settings

How to:

The Adapter for Siebel supports array retrieval from result sets produced by executing SELECT queries or stored procedures. This technique substantially reduces network traffic and CPU utilization.

The block size for a SELECT request applies to TABLE FILE requests, MATCH requests, and DIRECT SQL SELECT statements.


Top of page

x
Syntax: How to Specify Block Size for Array Retrieval
x
ENGINE SIBIN SET FETCHSIZE n 

where:

SIBIN

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

n

Is the number of records to be passed from the physical layer of the adapter, written in Java, to the logical layer, implemented in C. Accepted values are 1 to 5000.

1 indicates non-blocked communication. 1 is the default value.

This value is associated with all data retrieval operations and applicable to all segments.



Example: Testing Retrieval Performance

The following procedure uses the FETCHSIZE command to test retrieval performance. It shows the difference in milliseconds based on the FETCHSIZE.

-DEFAULT &FS = 50
SET PANEL=999
ENGINE SIBIN SET FETCHSIZE 1
-RUN
-SET &&STARTCPU = &FOCCPU;
-RUN
TABLE FILE ACCOUNT
SUM NAME ACCOUNT_COMPETITORS
ON TABLE HOLD
END
-RUN
-SET &DIFFCPU = &FOCCPU - &&STARTCPU ;
-TYPE1 CPU FetchSize= 1 : &DIFFCPU MS
-RUN
ENGINE SIBIN SET FETCHSIZE &FS
-RUN
-SET &&STARTCPU = &FOCCPU;
-RUN
TABLE FILE ACCOUNT
SUM NAME ACCOUNT_COMPETITORS
ON TABLE HOLD
END
-RUN
-SET &DIFFCPU = &FOCCPU - &&STARTCPU ;
-TYPE1 CPU FetchSize= &FS : &DIFFCPU MS 

iWay Software