Trouble with Query Limit

  • dorfdimpaler

    (@dorfdimpaler)


    4 years ago

    After the most recent WordPress upgrade, I started having trouble with my WordPress site blowing out the 75000 queries/hour limit of my host. My host said they’d gladly increase that limit for a princely sum. I’m trying to find ways around it.

    For the last year or so, I have been using your plug-in to give readers a taste of what’d in the weblog. I’ve got over 10,000 posts going back to 2004. The main categories concern Deer Hunting and Turkey Hunting, but there are several other hunting and shooting categories. I’ve been using your plug-in to showcase these older posts and threw out 3 other plug-ins that were doing similar jobs. My bounce rate has gone down and the pages-per-visit have gone up.

    The problem was that better than 500 of 800 queries executed by each displayed page were coming from your plug-in and caching wasn’t changing anything. I have turned off your plug-in until I can figure something out.

    Is there a means by which this plug-in could display its output in the body of a page? It’d be ripping good if I could just create a page for each “Department” and then display 20 random articles on a given subject. I didn’t see shortcodes.
    I’ve tried a couple of plugins that put widgets into pages, but neither were compatible with my theme.

    Another possibility I’ve thought of is asking you if you could add a caching option. That way, I could go back to putting multiple copies of your widgets and set the cache to expire after few hours. That way folks would get different content when they came back to the site, but not every time they hit the refresh.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Kybernetik Services

    (@kybernetikservices)

    Thank you @dorfdimpaler for reaching out.
    I do understand your request but unfortunately I can not help with this.
    Shortcodes are not provided by default.
    Recent Posts Widget With Thumbnails is not using a custom query to get the posts but is following the WordPress standard. I do use new WP_Query() to collect the posts.

    Because there is no custom query, I can not add a cache feature. But, the good part ist, I do use the WordPress standards. This gives you the possibility to use the WordPress options to speed up the query.
    Did you already check if you can get a persistent caching system, such as Memcached, enabled on your server?

    Beside this I will add a note on our roadmap for the plugin and I will check for an upcoming release if and how I can improve the query. But, nothing I can promise today.
    Hope you understand.

    Thread Starter dorfdimpaler

    (@dorfdimpaler)

    Thanks for the response. I kind of expected it.
    This is a super plug-in, and it has had a really positive impact on my site. Your’s is the only plug-in I’ve found that gives folks a random taste of 10,000 posts, and do so with a bit of flair.

    I’ve re-activated it after taking out some other fluff. I will try Memcached. I have tried cache plugins previously that turned out to be incompatible with other components.

    Plugin Author Kybernetik Services

    (@kybernetikservices)

    I’ve researched and could find settings for the cache behavior of WP_Query(). Not sure if this helps but I will give it a try and do some tests. If this helps I will implement it in one of the next releases. Stay tuned.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Trouble with Query Limit’ is closed to new replies.