If you execute multiple query groups, you must evaluate the number of working directories to be used to execute the query groups.
To execute multiple query groups, the working directories and query groups can be configured to have a 1-to-1 correspondence or a 1-to-n correspondence. The table below describes each configuration.
Table 2-6 Configurations of query groups and working directories
No. | Configuration | Description |
---|---|---|
1 | Configuration in which there is a 1-to-1 correspondence between a working directory and a query group | In this configuration, you create one working directory for each query group and execute one query group in one working directory. This configuration has the following advantages:
|
2 | Configuration in which there is a 1-to-n correspondence between a working directory and multiple query groups | In this configuration, you create only one working directory and execute multiple query groups in that working directory. This configuration has the following advantages:
|
Note that if the memory requirement for a single SDP server exceeds 1.6 gigabytes, we recommend that you use the 1-to-1 configuration in which there is a working directory for each query group.
If you execute nine or more query groups, determine the number of working directories to be used to execute the query groups (creating as many 1:1 configurations as there are query groups or creating multiple 1: n configurations) by referencing 2.7 Estimating the memory requirements.