Umbraco Forms Running Slow

Questions
,
1

Hi ,

I am looking after an old version 8 site, and found we are having a problem with forms, we have about 9000 form entries and about 10000 form individual entries for the forms.

The major problem is that when we go view form entries the CPU on the server is spiking to 100% use.

I assume the only way to correct this would be to upgrade the site to latest version of Umbraco and Forms.

The forms on the app are filled in using a Android App and custome code to post the data back to the forms.

2

Hi @darrenhunterEmerald

There could be multiple potential reasons why you may be seeing issues:

  • Do your forms contain file uploads? - large files especially can be an issue
  • Are you using any custom workflows/notification handlers that contain additional logic?
  • Do you have adequate resource to handle the number/frequency of submissions?
  • The sheer number of entries on the form may also be causing issues - though I don’t think data retention policies for Forms comes OOB till later verisons you may want to look at cleanup of old entries

Upgrading to the latest and greatest I’m sure would help as well (but obviously has the potential for a huge undertaking)

4

Hi,

There is some custom code in there to add forms from a JSON submission for the custom IONIC apps, that used on there Android Tablets.

All images that are posted are stored on the DB as well.

I assume it just the shar amount of data that caused the problem.

5

Hi yeah I can imagine most likely the case that the sheer amount of data would most likely be the issue and especially if your storing the images within the DB would be quite intensive, they would definitely be better suited in something like a dedicated blob storage or file system.