Question

Forms submit slow with data

Forms

Updated an hour ago

asked one day ago • Show version history

We have a modern form ( LF 12) that is basically a reporting form. User selects a few field filters and it populates a table with data.

At the bottom of the form we have a check box called "generate csv". If the user checks that box and submits the form, a workflow runs to generate the data is a csv and send it to them.

We are running into an issue when the data gets into the thousands of rows. The lookup on the form seems to handle it ok but when we submit the form is takes multiple minutes. It sometimes crashes as well (get the not responding error/wait).

We updated it so when checking the csv box, it hides the lookup table and ignores the data on the form. Yet it still crashes/takes 3-4 minutes to submit the form and we are not sure why.

We have checked the cf_data table and confirmed that all the data is NOT being saved to the db. We tested and did a small one with the ignore data enabled and disabled. When enabled it saved the values, when not it did not save the values.

Why would the form take multiple minutes/crash when submitting even when the data is hidden and not saved? Is there a way around this?

Thanks,

Chris

0 0

Replies

replied 22 hours ago

Have you checked the event viewer logs?

0 0

replied 21 hours ago

Nothing during the time of testing. Again the form eventually submits but it takes a good 3-4 minutes. It is the form submission as during that time the workflow has not started yet. The workflow then starts once the form finally submits.

It seems that if the form has thousands of data rows the submit takes a really long time. I guess that somewhat makes sense but not if we hide the fields a choose to ignore the data. I would think that would submit right away.

Our workaround is to have two different forms. One for displaying data and one for downloading. The form where you can download does not show resulting data on the form so it submits normally.

Looking to see if there is a bug or a setting we can change to we can submit the form normally.

0 0

replied 16 hours ago

Do you have the process set up to "load next task when workflow completes" that would cause it to hang.

I don't have a big enough table to check over 1200 rows, but my 1200 row form submitted in <1 second

0 0

replied an hour ago

Nothing checked as far as that goes. Its the starting form, a gateway that checks if the box is checked, and a workflow task. If the box is not checked it ends. If the box is checked the workflow runs and then ends.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms submit slow with data

Replies

Sign in to reply to this post.