How to: Reference: |
The SET SUWEDGE command provides a mechanism for keeping Master Files in memory on a FOCUS Database Server even though no users are accessing the files. This enhances performance by eliminating repeated parsing of Master Files on FOCUS Database Servers that have a large number of users running multiple applications using different files on the server.
You can specify that a number of files be wedged open, that specific named files be wedged open, or a combination of both. The maximum number of files that will be wedged open is 256, regardless of how many you specify.
Place one or more of the following commands in the server profile (PROFILE HLI):
SET SUWEDGE = {n|ddname} [,ddname ...]
where:
Is a number of Master Files to be wedged open. You can specify any number, but once 256 files are wedged open, additional files will not be wedged. The default is zero.
Is the ddname of a specific file to be wedged open in addition to the n files specified by number (if any).
Note: To set both a number of files to be wedged and one or more specific ddnames to be wedged, you can issue the SET SUWEDGE command multiple times or specify multiple options in one SET SUWEDGE command. Specific ddnames are not counted in the number of files specified (as long as the total does not exceed the maximum number of wedged files allowed). If you specify a number multiple times, the last one specified is the one used.
The following commands wedge open any three FOCUS data sources plus the EMPLOYEE and CAR data sources:
SET SUWEDGE = 3 SET SUWEDGE = EMPLOYEE SET SUWEDGE = CAR
or
SET SUWEDGE = 3 SET SUWEDGE = EMPLOYEE, CAR
or
SET SUWEDGE = EMPLOYEE, CAR SET SUWEDGE = 3
or
SET SUWEDGE = 3, EMPLOYEE, CAR
Information Builders |