You are viewing limited content. For full access, please sign in.

Question

Question

Forms submit slow with data

Forms
Updated August 20
asked on August 18 • 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 on August 18

Have you checked the event viewer logs?

0 0
replied on August 18

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 on August 18

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
View 1 previous reply
replied on August 19

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
replied on August 19

On your starting form in the process diagram, this is the checkbox I was referring to.

Otherwise, does your table have any formulas in it? Or is all of the table data populated by the lookup?

Do other forms take longer than normal to submit or is it just this one?

0 0
replied on August 19

Yep, thats the box that is not checked.  No formulas currently and yes the table is only populated by a lookup (fields are read-only).  All other forms submit normally its just this one.

0 0
replied on August 20

I'm unfortunately out of ideas, I would suggest opening a support ticket

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...