Support » Plugin: Contact Form DB » Contact form database for large number of entries

  • Hi,

    We have over 20,000 entries in our contact form database, so right now the back end area of our website as well as the front end page that displays shortcodes to embed all the names of the people in the database are taking a really long time to load.

    Are there specific memory settings in the php.ini file or any other general settings I can adjust to help speed up this process? Sometimes it takes over 5 minutes to load.

    Thanks!

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    For short codes, try adding unbuffered
    e.g.
    [cfdb-table form=”form1″ unbuffered=”true”]
    That might help a little.

    Memory setting will not likely make it faster. It is probably the DB query being slow. I don’t have an immediate fix for you on that.

    Thread Starter dhobeika

    (@dhobeika)

    Thanks so much for the fast reply!

    So there is no way to get the back end in the WordPress admin dashboard loading better? Right now, it’s not even loading to the point that allows me to search and edit entries. It loads the list, but it doesn’t load to the point that would allow me to edit the content of the fields that were submitted, nor search them. And then it stops loading, so the ability to search and edit will never load.

    I would normally take a screenshot to document the issue, but it has people’s names and contact information that I shouldn’t display on a public forum.

    Plugin Author Michael Simpson

    (@msimpson)

    As a stop-gap, you could create a private page and put a short code like

    [cfdb-datatable form=”form_name” edit=”true” filter=”submit_time>1 month ago”]

    That gives you an editable the last month’s entries of a form. That will avoid some of the extra stuff that the admin page does, so it might be faster and easier to deal with.

    Thread Starter dhobeika

    (@dhobeika)

    Thanks. The issue is that I often have to edit older entries that date back to December 2013. I could create a private page as you mention and adjust the time frame according to whatever the submission date was on the entry that needs editing, but without the search function to find the entry, it’s hard to find the date of submission.

    Plugin Author Michael Simpson

    (@msimpson)

    Go into your PHPMyAdmin and run this command:

    OPTIMIZE TABLE wp_cf7dbplugin_submits

    and let me know message it gives. It may be “Table is already up to date” but if not it might speed things up.

    Thread Starter dhobeika

    (@dhobeika)

    Thanks! I just tried that (except I replaced wp_ with ybz_ since I think my hosting company uses random prefixes to avoid potential hacking) and this is the message I got:

    mydatabaseusername_mydatabasename.ybz_cf7dbplugin_submits optimize status OK

    (replaced my database username and database name for security purposes)

    I tried to load the database in the backend and still had the same issues unfortunately.

    Thread Starter dhobeika

    (@dhobeika)

    I just found that a recent update to the BotDetect CAPTCHA is what was causing the dashboard database to not finish loading. I just disabled it and now it’s loading to the point where I can search and edit, albeit it still takes a long time to load, but at least I can edit again.

    Thanks so much for your help!

    dhobelka, I just asked a question of you on another forum post, but it looks like you did use Contact Form 7 and Contact Form DB for the large number of submissions. Are you happy with that choice? Did you run into any issues other than the issue you outlined here? Did you use CloudFlare with your website to help process the requests? I’m about to embark on a similar journey and want to make sure I know what I’m getting into so the site doesn’t crash and we don’t lose data!

    Hi, i am interested to know if it’s possible to paginate the shortcode query results? So that it will not have to load / display all the names at once

    Plugin Author Michael Simpson

    (@msimpson)

    You can use the limit option to restrict the number of rows but you would have to work out for yourself how to make that paginate. If you do load all the rows into the page then the datatable component will paginate over the results that are loaded in the page.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Contact form database for large number of entries’ is closed to new replies.