Performance Tips: Oracle

General

  1. Please always use the most recent version of Bingo.
  2. Please store as little data as possible in the indexed table. See the “Performance Notice” in the user manual for details.
  3. Oracle 10 and 11 usually perform better than Oracle 9.

Indexing

  1. Please turn off the ARCHIVELOG option in your database instance. This saves a significant amount of time and disk space during indexing.
  2. Bingo takes advantage of multi-core processors. The number of indexing threads is detected automatically. If you want, for some reason, to use some specific number of threads, use the NTHREADS indexing parameter.
  3. You can disable the computation of specific fingerprint parts (saving both time and disk space) by setting the relevant parameter to zero. See the corresponding section of the user manual for details.