Improving performance in Laserfiche Forms versions 10.3.1 onward

Customers may experience performance issues when there are instances with thousands of instance step histories in the system. This article provides a more permanent solution than restarting the routing service periodically.

This solution applies to Laserfiche Forms versions 10.3.1 and later.

Starting with 10.3.1, a new option was introduced in the cf_options table to limit the number of completed tasks to be displayed. Prior to 11 Update 3, intermittent performance issues may be encountered with the default GridLoadLimit value of 5000, which consumes resources and is extremely slow when there are instances with thousands of step histories.

Resolution

Decrease the GridLoadLimit value to 100, which is the default value from 11 Update 3 and later.

Use the following simple SQL script to alter the GridLoadLimit value:

IF EXISTS (SELECT *
          FROM   cf_options
          WHERE  optionname = 'GridLoadLimit')
  BEGIN
      UPDATE cf_options
      SET    optionvalue = 100
      WHERE  optionname = 'GridLoadLimit'
  END
ELSE
  BEGIN
      INSERT INTO [dbo].[cf_options]
                  ([optionname],
                   [optionvalue])
      VALUES      ('GridLoadLimit',
                   100)
  END