Form Wizard Pro: additional index

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
4/14/2020 6:28:41 PM
Gravatar
Total Posts 1196
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Form Wizard Pro: additional index

Hi, guys. I wanted to report a performance issue. As you know we've been running our site with Form Wizard Pro for almost ten years now. Our sts_webformresponse table is up to 77 MB in size. We'd noticed that performance in saving form responses had gotten very bad, so I took a look and found this statement in particular running slowly:

SELECT  wfr.*, rs.UserGuid, rs.CreatedUtc
FROM    sts_WebFormResponse wfr
JOIN sts_WebFormQuestion wfq ON wfr.QuestionGuid = wfq.Guid
JOIN sts_WebFormResponseSet rs ON rs.Guid = wfr.ResponseSetGuid
WHERE wfr.ResponseSetGuid = 'xxx'
ORDER BY wfq.SortOrder;

I was able to speed this statement from as slow as 14 seconds in our environment down to .01 seconds by adding an index on sts_webformresponse.ResponseSetGuid

Judging by the MySQL slow queries log, I think there may be some other areas of the database where performance can be improved. Would you prefer me to report them here or on Github?

Thanks,
Jamie

6/8/2020 3:49:17 PM
Gravatar
Total Posts 2183

Re: Form Wizard Pro: additional index

Hi Jamie,

Thanks for this! We'll get it added to formwizard for sure.

Thanks,
Joe

You must sign in to post in the forums. This thread is closed to new posts.