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"
Ignore (Consumes 45% of DTU. Wondering is it same for any of you also? ) for above Job.
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:
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.
That does not sound right. I will file a bug to Forms team
Thanks Quan Mai, much appreciated.
@Jannes Kruger Can you please confirm if this fix works for you, for us the problem is still there.
@Diep Nguyen, Can you please provide an example for creating indexes on tblBigTable?
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)