Extreme poor performance of "Form Submissions Cleanup" Schedule J

Extreme poor performance of "Form Submissions Cleanup" Schedule Job

K Khan

Vote:

EPiServer Forms: 4.25.0
EPiserver CMS: 11.12.0

For us, 'Form Submissions Cleanup' job takes 45 mins and more

Consumes 45% of DTU. Wondering is it same for any of you also?

(Investigations are in progress)

Best Regards
Khurram

#205812

Jul 24, 2019 12:12

Quan Mai

Vote:

Forms are stored on DDS so if you have a big number of forms submitted and if a considerable amount of that need to be deleted, it will be slow. Not saying 45 minutes is totally fine, but it sounds to me it is kind of "reasonable range"

#205814

Jul 24, 2019 12:58

K Khan

Vote:

Ignore (Consumes 45% of DTU. Wondering is it same for any of you also? ) for above Job.

#205821

Jul 24, 2019 16:01

Jannes Kruger

Vote:

Hi guys,

I know this is an old Thread, but I have a similar experience and did not want to start a new thread.

Current versions for CMS and Froms:

EPiServer.Forms.UI 4.27.1.0

EPiServer.CMS 11.14.2.0

The "Form Submissions Cleanup" job runs for over 12 hours, retention is currently set to 30days. There is around 300 form submissions per day. Is this performace to be expected?

What are the steps we can take to try and lower the performace and cost considerations? Your advice and guidance will be greatly appreciated.

#222857

May 12, 2020 12:07

Quan Mai

Vote:

That does not sound right. I will file a bug to Forms team

#222860

May 12, 2020 14:35

Pinkesh Jain - Mar 24, 2023 5:01

Hi Quan,

In our case it took 451 m to clean up just 94 expired forms. The amount of time increases as the larger clean up is required.
Is there any update on that bug?
Is there a ticket we can track/review progress to see if we can fix this?
Thanks.

Quan Mai - Mar 24, 2023 7:24

the bug is AFORM-2579 and should be fixed in Forms 4.30.3

Jannes Kruger

Vote:

Thanks Quan Mai, much appreciated.

#222865

May 12, 2020 15:46

K Khan

Vote:

@Jannes Kruger Can you please confirm if this fix works for you, for us the problem is still there.

#298905

Mar 24, 2023 8:33

Diep Nguyen - Mar 27, 2023 8:47

we are working on it but creating indexes for tblBigTable would also help a little bit.

Pinkesh Jain - Mar 27, 2023 10:25

Completely agree with you Diep. We created index on tblBigTable and that helped a lot in performance.

Quan Mai - Mar 27, 2023 10:28

A word of warning - tblBigTable -i.e. DDS can be very rigid on which indexes that can be added to which columns. you should be careful

K Khan

Vote:

@Diep Nguyen, Can you please provide an example for creating indexes on tblBigTable?

#299041

Edited, Mar 27, 2023 9:09

Diep Nguyen - Mar 28, 2023 3:13

It is better that should wait for our team to fix this addon.
Thanks.