FrmDb::check_cache 4000 queries

  • Resolved annaam

    (@annaam)


    9 months, 1 week ago

    Hi,

    Thanks for making such a great plugin.

    I’m having an odd occurrence of sometimes, when loading a page that has a formidable form, I see in the query monitor FrmDb::check_cache queried over 4000 SELECT statements, all looking somewhat like this:

    SELECT *
    FROM wp_frm_items
    WHERE post_id=71818
    LIMIT 1

    1. FrmDb::check_cache

    SELECT *
    FROM wp_frm_items
    WHERE post_id=71819
    LIMIT 1

    1. FrmDb::check_cache

    SELECT *
    FROM wp_frm_items
    WHERE post_id=71820
    LIMIT 1

    1. FrmDb::check_cache

    SELECT *
    FROM wp_frm_items
    WHERE post_id=71821
    LIMIT 1

    1. FrmDb::check_cache
    etc…

    Any idea what’s going on?

    Best,

    • This topic was modified 9 months, 1 week ago by annaam.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Jonathan Martínez

    (@jonathanenlared)

    9 months, 1 week ago

    Hey @annaam

    Thank you for reaching out about this.

    Our dev team shared the following:

     It just looks like it’s querying for entry data for specific post IDs. They’re likely loading data for many entries that have an associated post – from using a Create Post action.

    These queries should all be possible to cache so they don’t happen on every page load. If they could set up object caching, it would make a big difference.

    You can reach out to ghosting support team and ask about setting up an object caching service for your website.

    Thread Starter annaam

    (@annaam)

    9 months, 1 week ago

    We do already use an object cache service. I’ll look into our code and see if I can figure this out.

    Thanks,

    Plugin Support Jonathan Martínez

    (@jonathanenlared)

    9 months, 1 week ago

    Of course, please let us know what you find. Have wonderful day ahead.

    Thread Starter annaam

    (@annaam)

    8 months, 3 weeks ago

    Hi, is there a chance the developer could elaborate on this:

    It just looks like it’s querying for entry data for specific post IDs. They’re likely loading data for many entries that have an associated post – from using a Create Post action.

    The problem page(s) simply show a typical form if the user has not already submit an entry.

    Plugin Support Njones35

    (@njones35)

    8 months, 3 weeks ago

    Hi @annaam

    I’m afraid that WordPress forum rules only allow us to support the free “Lite” plugin here.

    Since your question relates to the “create post” functionality in our paid plugin, can I ask you please to open a ticket in our helpdesk here for help with this: https://formidableforms.com/new-topic/?supportform=true

    Thank you,
    Nathanael

    Thread Starter annaam

    (@annaam)

    8 months, 3 weeks ago

    I deactivated and removed the plugin Formidable ACF, which resolved the issue.

    It seems like if a site has the plugin Formidable ACF active but isn’t mapping it, it can cause this issue.

    Just an FYI for people with similar issues. No further help needed.

    Thanks,

    • This reply was modified 8 months, 3 weeks ago by annaam. Reason: clarity
    Plugin Support Njones35

    (@njones35)

    8 months, 3 weeks ago

    Hi @annaam

    We can’t help with Pro features like the ACF add-on here.

    For issues with Pro features you will need to open a ticket here: https://formidableforms.com/new-topic/?supportform=true

    Thank you,
    Nathanael

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘FrmDb::check_cache 4000 queries’ is closed to new replies.