Advanced Settings

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 -0i.

  • 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.