attorney
Member
I have a form on our test site here: http://m00.biz/iRMost
It uses a few conditionals, nothing too major, and we have specifically not required a checkbox I agree due to some trouble I saw here earlier. Unfortunately i cannot get this form to complete the submission and kick off to the next destination. It does register the user but it sits there with a spinning cursor indefinitely. Can't explain why.
Tried your form in a couple of different browsers with no hang-ups or problems. Looks like both submissions completed successfully. Since you're form isn't currently set to redirect to another page I can't really test that.. Also, if you're redirecting a single page form to a new page for the confirmation, you really don't need to have Ajax enabled.
Lastly, I'm not really sure what you mean by this..
and we have specifically not required a checkbox I agree due to some trouble I saw here earlier
The checkboxes work just fine for "agree to terms" type applications if you set them up right. If you need help with that, you can start a new topic and someone can assist you.
attorney
Member
Kevin - Thanks for the reply. You can try it now. I ended up using a dropdown which isn't ideal but I may like it better. I'll try the checkbox again.
You can see the hanging behavior on the server. Even the back end is slow. We do have 40,000 members on our site. I don't know if Wordpress is the culprit. Our hardware is excellent, it is not taxed by current traffic and seems to respond slowly at times on the back end using Gravity Forms and especially now with registration. I have found that the redirect will eventually work but using the page redirect within Wordpress does not.
attorney
Member
Here is what I'm looking at... the insert into the wpusers and then wpmeta takes forever. Personally I don't understand the purpose of the wpmeta table at all. IMHO it's like a normalization 101 mistake but, then again, I'm just an amateur hack.
mysql> show processlist;
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
| 61316 | mysite_myadmin | localhost | mysite_mydb | Query | 0 | NULL | show processlist |
| 64110 | mysite_myadmin | 10.10.10.33:55782 | mysite_mydb | Sleep | 0 | | NULL |
| 64122 | mysite_myadmin | 10.10.10.33:55794 | mysite_mydb | Sleep | 0 | | NULL |
| 64228 | mysite_myadmin | 10.10.10.33:55917 | mysite_mydb | Query | 10 | update | INSERT INTO wp_users (user_pass,user_email,user_url,user_nicename,display_name,`user_reg |
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
mysql> show processlist;
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------+
| 61316 | mysite_myadmin | localhost | mysite_mydb | Query | 0 | NULL | show processlist |
| 64110 | mysite_myadmin | 10.10.10.33:55782 | mysite_mydb | Sleep | 0 | | NULL |
| 64122 | mysite_myadmin | 10.10.10.33:55794 | mysite_mydb | Sleep | 0 | | NULL |
| 64228 | mysite_myadmin | 10.10.10.33:55917 | mysite_mydb | Query | 0 | update | INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('44143','first_name','') |
+-------+-----------------+-------------------+-----------------+---------+------+--------+------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
attorney
Member
I wonder how many users you have in the database and how it's relatively quick.. how do you guys manage to optimize performance as the usermeta table grows? With GF, it seems like a growing usermeta can be deadly to performance. As I said, with my users / usermeta up at 40,000, I'm seeing GravityForms crawl and also registration. Viewing posts, pages and other items are very fast.
Any tips? Would be interested to see what you can find out by looking. Thank you for the great support here.
