Hi,
Thanks for reply.
Statements like ‘create table’ are very ‘heavy’ in database terms. They require a expensive locking mechanism. We noticed that the above mentioned sql is executed every time a user visits a page containing the form. If you have busy site this leads to congestion in mysql. In our case on average statements like ‘create table’ take about 3 seconds (!)
If I could suggest some kind of improvement, you could consider:
1. executing sqls that create, change etc db during the installation and upgrade of the plugin.
2. using “select from information_schema” to check if all necessary tables are craeted and have all columns etc.
