Settings related to the time-out period, error and infinity handling, step-wise
aggregation, and blocking level.
- Time-Out Period
- When running long queries, your browser may time out after
several minutes. You should be able to eliminate many of the time-outs by changing this
setting to the time-out interval (or lower).
For example, if you are timing out after
five minutes, set this to five minutes. If you are timing out after seven-and-a-half
minutes, set it to seven minutes.
Please be aware that when a time-out period is
set, your browser's progress bar may not function properly.
Note: Time-outs are usually caused by your proxy server or firewall. If you experience
such time-outs, first speak to your technology support person to see if they can
change your proxy server or firewall settings. If that's not possible, then try
changing this setting.
- Error and Infinity Handling
- Some computations (e.g., dividing by zero) can result in errors
or "infinity" values (0I, -0I,
0i, or -0i). Selecting this
option can help reduce or eliminate this behavior.
- Division by zero (X/0) returns
0i or -0i if the
numerator is not zero.
Checking this box causes N/A
to be returned instead of 0i and
- Exponentiation (X^Y) can generate error messages if
X is negative.
Checking this box mostly eliminates
such messages and causes N/A to be returned in the
event of an error.
- The range functions (range1, range1f, etc.)
return 0I, -0I,
0i, or -0i for column
values that lie outside the specified ranges.
Checking this box causes
N/A to be returned instead.
- Do step-wise aggregation
- Select this option to help alleviate virtual memory problems
when working with large tables. Using this feature saves memory but is slower.
- Blocking Level
- Select lower numbers to help alleviate virtual memory problems
when doing row selections and tabulations on large tables. Lower numbers save memory but
may cause queries to run slower.