Views:
Question:
Why is my performance decreasing after a fulltext reindex?
 
Answer:
When starting a fulltext reindex of any option, a task will be created in the DWSystem database > DWTasks table. The fulltext reset will start a task of the TASK_TYPE 5, which will create separate tasks of the TASK_TYPE 0 and 2 (Textshot and Fulltext creation).
This fulltext reindex can cause a higher load on the database, which may result in Performance issues. This commonly happens with slower databases, as they might not be able to process all incoming reindex tasks in time, which could cause the DWTasks getting full. In some cases, this can even lead to database outages. Other modules like the Autoindex could therefore also be affected.
In such a case, you will most likely see a higher number of tasks. Some tasks might have a higher TRY_COUNT, which indicates timeouts of single processes.
If you have multiple tasks of the type 5 and the table is getting filled by many other tasks (several hundred entries), then you might need to delete the entries of the DWTasks table.

 
First, before you make a change, please create a backup of the DWSystem database
  1. Stop the Brackgroundprocessservice and the Fulltext Server
     
  2. Open your database “DWSystem” and the table DWTasks
     
  3. Delete all entries of the TASK_TYPE 5 with the filter “WHERE TASK_TYPE = 5”.
    If there are too many entries of the type 0 and 2, which are not processed you, might need to repeat it with those tasks as well ” WHERE TASK_TYPE = 0 AND TASK_TYPE = 2”. 

    Please do not delete any other tasks!

     
  4. Now start both services again and start a fulltext reindex for only one file cabinet. 
    You will need to choose the option “Reindex unprocessed documents and failed fulltext extractions”.
    This has to be done with all file cabinets, which had before a running reindex (TASK_TYPE 5).

    Please do only one Fulltext reset at a time.

     

If the DocuWare services are affected by performance issues because of the fulltext search or a running fulltext reindex, please follow the following recommendations:
 

  1. Be aware to only have one fulltext reindex running at a time. 
     
  2. Assign the fulltext server more memory, that it can work with optimal resources to avoid unnecessary load on the CPU of the system.
    For this, navigate to the fulltext server path (by default in the path “C:\Program Files\DocuWare\Full-Text Server (x64)”) and run “configdwtomcat.cmd“.
    Then navigate to the tab “JAVA” and increase the parameters “Initial memory pool“ and “maximum memory pool“ as desired high (see screenshot below).


     
  3. Set up a schedule for the Fulltext reset task: Scheduling heavy Fulltext operations
     
  4. Increase or reduce the Imaging Worker process count: Full-text Imaging Worker process CPU load too high
     
  5. Install the Fulltext Server on a different machine