Form results incredibly slow FIXED

Permalink Browser Info Environment
Formidable took 9 seconds to display results for a form that had 3 responses, any more than that and it would never finish.

I solved the issue by adding indexes on the FormidableAnswers table:

ALTER TABLE `FormidableAnswers` add KEY `formID` (`formID`);
ALTER TABLE `FormidableAnswers` add KEY `answerSetID` (`answerSetID`);


Not sure if this is still an issue in the current version of the addon, though I'd urge the addon developer to fix this in the db.xml.

Type: Discussion
Status: Resolved
Korvin
View Replies:
DeWebmakers replied on at Permalink Reply
DeWebmakers
Hi Korvin,

Can you check if there is an INDEX on the fields answerSetID, formID and elementID?
It should be there, or you have an older version.

Best,

Corretje

concrete5 Environment Information

.

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.