Improving the Speed of Within-Folder Searches

August 31, 2018 | KB: 1013978
Laserfiche 10

Summary

When using the repository's search function to look within a specific folder, the search can take a long time if there are many entries in the folder. You can insert a special database option to make the search faster. This only applies to Laserfiche Server 10.2.1 and later.

To make within-folder searches inside folders with many entries faster

  1. Backup the repository database.
  2. Run the following command on the database:

    Insert into DBOPTIONS values('SearchLookinThreshold','0').

  3. Restart the Laserfiche Server service.

Note: Setting SearchLookinThreshold to 0 can slow down within-folder searches when those folders have very few entries.