General
- Please always use the most recent version of Bingo.
- Please store as little data as possible in the indexed table. See the “Performance Notice” in the user
manual for details.
- Oracle 10 and 11 usually perform better than Oracle 9.
Indexing
- Please turn off the
ARCHIVELOG options in your database instance. This saves a lot of time and disk
space during indexing.
- Bingo does take advantage of multi-core processors. The number of indexing threads is detected
automatically. If you want, by some reason, use some specific amount of threads, use the
NTHREADS
indexing parameter.
- You can disable the computation of specific fingerprint parts (saving both time and disk space), setting
the corresponding parameter to zero. See the corresponding section of the user manual for details.
Search
- While running the search queries, try not to close your SQL session until you really need to close it.
See the note the user manual for details.
- Please increase Oracle's “database buffers” parameter as large as you can, given the amount of memory of
the server. This step may require activation of manual memory management in Oracle.