Variables to Enhance Performance

Use the SPDSNETP= macro variable to size buffers in server memory for the network data packet.

SPDSNETP=size-of-packet

Default:32K

Corresponding Table Option:NETPACKSIZE=

Arguments

When sizing the buffer for data packet transfer between SPD Server and your SAS client machine, the packet must be greater than or equal in size to one table row. See NETPACKSIZE= for more information.

Despite recent upgrades to your network connections, you are experiencing significant pauses when the SPD Server transfers data. You want to resize the data packet to send three rows at a time for a more continuous data flow.

Specify a buffer size in server memory that is three times the row size (6144 bytes.) Submit your SPDSNETP= macro variable statement at the top of your job.

%let SPDSNETP=18432; 

Use the SPDSSADD= macro variable to specify whether SPD Server appends tables by transferring a single row at a time synchronously, or by transferring multiple rows asynchronously (block row appends).

SPDSSADD=YES|NO

Default:NO

Related Table Option: SYNCADD=

Arguments

SPDSSADD=YES slows performance. Use this argument only if you require strict compatibility with Base SAS software when processing a table. For a complete discussion, refer to SYNCADD=.

Use the SPDSSYRD= macro variable to specify whether SPD Server should perform asynchronous data streaming when reading a table.

SPDSSYRD=YES|NO

Default:NO

Related Table Option: SYNCREAD=

Arguments

Description

Use SPDSSYRD=YES only with a MODIFY statement. If you use it with any other processing operation, you slow performance.

Use the SPDSAUNQ= macro variable setting to specify whether to cancel an append to a table if the table has a unique index and the append would violate the index uniqueness.

SPDSAUNQ=YES|NO

Default:NO

Description:

Use SPDSAUNQ=YES macro variable to improve append performance to a table with unique indexes. If uniqueness is not maintained, the append is canceled and the table is returned to its state before the append. In such an instance, you can scrub the table to remove nonunique values and redo the append with the macro variable SPDSAUNQ= set to YES. The other alternative is to simply redo the append with the macro variable SPDSAUNQ= set to NO.

If SPDSAUNQ=NO, the SPD Server will enforce uniqueness at the expense of appending unique indexes in observation order one row at a time. If uniqueness is not maintained for any given row, that row is discarded from the append.