Issue with options table

Say, we are having an issue with the websites option table . Wanted to see if this is something you are able to take a look at or recommend someone to take a look.

I can confirm that on average admin-ajax requests are being completed in less than 2 seconds, it appears to be specifically Ninja Forms based admin-ajax requests which are taking longer to complete.

Your site’s database is currently very large at 3.4gb (the average Wordpress database is around 500mb), this can cause requests to take a significant amount of time to complete especially when they’re interacting with large datasets. The majority of this space is being used by the wp_q6ukxb7r93_options table which is 3.3gb, this is strange as the options table is typically under 100mb.

When a change is made on NinjaForms it attempts to query the options table however due to it’s size this query takes a long time to complete. The best way forward here would be to work with a developer to clear out whatever is causing the bloat within the options table after which you should see the response time lower significantly.

Hello @rkassebaum,

Thanks for writing in! On a typical Pro theme, there are only around 600 rows in the wp_options table. If you can access your database, check your wp_options table and see how many rows it contains. A plugin may be causing the issue or there are a huge number of transients being saved in your table. You may need to install a 3rd party plugin that cleans your database.

Best Regards.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.