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?