Estimating the size of the FTS index


Place the FTSindex in a directory that has sufficient disk space. The directory must be large enough to accommodate at least twice the amount of data indexed for FTS. For example, if the total amount of data in all fields to the index for FTSin all forms is 100 MB, then at least 200 MB of disk space is required for the indexes. This example is only an approximation.

 To estimate the size of the FTSindex

  1. Estimate the amount of text in your database.
    For example, take a small sample of requests and calculate the average size of data in the field. Then, multiply this average by the number of AR System server requests to derive the size of the text in your database.
  2. Multiply by a minimum of 2.
    The ratio of the size of the FTSindex to source text can differ widely based on, for example, the size of your Ignore Words List.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*