On some cases, particularly when you have large form, the MySQL database will need to be fine tuned.
If you're having many large forms, here's the complete solution:
Follow these steps:
1 - Make a database_dump and stop the SQL engine
2 - Edit MySQL configuration file (my.cnf file) and set below
[mysqld]
innodb_file_per_table = 1
innodb_file_format = Barracuda
3 - Restart the MySQL server
4 - Run the following SQL for every table which is affected:
ALTER TABLE %%Name%%
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
Note: replace %%Name%% with affected table.
If you only have one large form, you can try step #4 directly. Run the query above using phpMyAdmin or any other SQL console.
