Support » Plugin: CF7 Google Sheets Connector » Can number of rows affect speed?

  • Resolved Leachimster

    (@leachimster)


    Hello, we are using this plugin on our site and submission is very slow, 10+ seconds.

    I have cloned site onto dev enviroment on same hosting, but switched to empty table and load times dropped to 3, max 4 seconds.

    Our main table has 3700 rows with 34 columns.

    We are running latest version of CF7, CF7 Google sheets connector and WP. Hosting provider is wpengine.com

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Abdullah WesternDeal

    (@westerndeal)

    Hello @leachimster
    Thanks for using this plugin.

    Rows doesn’t matter but yes number of columns matters, if there are more columns then slightly it will take time to submit entries to google sheet.

    To submit form with 2 to 5 seconds is normal if there are more entries. Hope my response helps you. Let me know if needed any further assistance.

    Thanks
    Abdullah

    Leachimster

    (@leachimster)

    We would be ok with 2-5s, but nowdays we are getting 10s+ which is too long. Is there any solution how to improve speed and not sacrificing any data within sheet?

    Sheet in CSV format has 1.8mb.

    Plugin Author Abdullah WesternDeal

    (@westerndeal)

    @leachimster

    Are you using any other CF7 Addons?
    Can you enable log errors to see errors or any other plugin conflicts

    Can you check what error is printed in the log.txt file? You can open it up via the Google Sheet Integration Page. Send us the latest log.

    If log.txt file is blank then enable WordPress debug by adding the following code in the wp-config.php file before /* That’s all, stop editing! Happy publishing. */ and submit the contact form again.

    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    define(‘WP_DEBUG_DISPLAY’, true);
    define(‘SCRIPT_DEBUG’, true);
    define(‘SAVEQUERIES’, true);

    This helps to understand and help you out further. Let me know

    Thanks

    Leachimster

    (@leachimster)

    Prior testing I have disabled all other CF7 plugins and all other non required plugins.

    Logging is enabled, there are no errors and log.txt is empty. There are some PHP notices in debug.log, but not related to this issue. No warnings, no fatals.

    When I switched production env to empty table, time was under 4s in five submissions. After changing back to main table I had 10.84s, 9.26s, 9.59s and so on, so it looks like only the size of stored data is causing this issue.

    Plugin Author Abdullah WesternDeal

    (@westerndeal)

    @leachimster

    I think you would be required to first solve the current errors printed in your debug file because this might affect the execution time. As no error is printed related to CF7 GSheet Connector so there seems no issue with it.

    Can you disable those plugins for which error is printed and then check if that fixes your issue.

    Let me know.

    Leachimster

    (@leachimster)

    Those logs are only notices from theme which do not affect speed of this script, since they are not used in ajax requests. There are 2 notices, which could potentially affect performance by <1ms and are not related to this issue.

    As I mentioned, speed dropped down to original load times after switching connection to blank table instead of populated one. If you wish, I can make xdebug report on localhost from empty and from populated.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Can number of rows affect speed?’ is closed to new replies.