Question

Poor performance in forms

Forms

Updated November 11, 2019

asked on November 6, 2019

Hello everyone.

I want to tell you about a situation that occurs in a client at Laserfiche Forms level

We have a series of automated processes, which are carried out every day, this has caused 197577 instances in total and 5788 instances currently running.

However we have been noticing a low data load performance when entering the monitor, sometimes we have to wait up to 3 minutes to load the page.

In addition, when users try to generate a report of some process, it also has a long duration of processing, sometimes up to 10 or 15 minutes and what worries us most about this is that during the loading of the report, the system as such performance is extremely low, and users call us indicating that the system does not complete tasks or the tasks assigned to them do not reach them. Until the report is completed or canceled the system is normalized.

We are concerned that the instances will continue to increase, so will the system remain as slow or even worse?

I would like to know your comments about it.
Thank you.

Total instances

Instances in progress

0 0

Replies

replied on November 6, 2019

What kind of resources have you allocated to the server? Honestly that is a LOT of instance data so I'm not at all surprised you are seeing slow load times.

Keep in mind that Forms instances involve data joined from multiple sources, so when you try to generate a report that is a lot of data to join and filter and the larger the datasets the higher the workload.

We currently have about 117,821 total instances with around 1,200 active at any given time. We are seeing about 20,000 new instances each month.

After seeing some slowdown we increased our web server resources to 12 virtual processors (2.69GHz each) with 32GB RAM and everything has been running pretty smooth.

We also scheduled a weekly restart to give the routing service a fresh start each week.

2 0

replied on November 7, 2019

The server has the following resources:

Processors: 8 (2.40 GHz)

RAM: 32GB

0 0

replied on November 7, 2019

One question, Jason, why is it good to restart the form routing service?
We have done it on a couple of occasions and rather we have suffered the loss of tasks or the terminated instances.

0 0

replied on November 7, 2019

We've found that with such a large amount of instances/activity, the automated garbage collection for .NET just couldn't quite keep up in the long-term.

We actually restart the entire server, not just the service, but we found that over time it would eventually eat up almost all of the system memory.

The garbage collection would kick in and it would drop back down eventually, but not before it started causing performance issues for the users.

Basically, with how many instances and users we have, it just built up too fast. The weekly restarts keep things running cleanly enough that it never happens.

Something worth noting is that if you restart the service when you're already having problems, it is more likely to cause the problems you described because it is already struggling.

We restart the server on Sundays at like 3AM, while it is still running smoothly, and we haven't had any lost tasks or terminated instances from those restarts.

Restarting the service when the server is struggling is more like holding the power button to force your PC to shut down, a scheduled server restart is a much cleaner process.

2 0

replied on November 6, 2019 • Show version history

What version of Forms is this? I recall there were performance enhancements to reporting on large numbers of instances in more recent releases.

0 0

replied on November 7, 2019

We are currently in the next version:

0 0

replied on November 8, 2019

Do you have a lot of variables in your processes? Also, when you notice monitoring performance issues, is that when loading "All processes" or loading data for a specific process?

0 0

replied on November 8, 2019

Yes, we have a considerable amount of variables in the processes.
And the low performance is presented in both situations

0 0

replied on November 11, 2019

I see. In 10.4.2 I did make some improvements that should improve report/monitor loading speed for processes with many variables. However, it won't impact "All processes".

1 0

You are not allowed to follow up in this post.

Question

Question

Poor performance in forms

Replies

Sign in to reply to this post.