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.
ENGINE SIBIN SET FETCHSIZE n
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
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.
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 |